Kaganapan
Power BI DataViz World Championships
Peb 14, 4 PM - Mar 31, 4 PM
Sa 4 na pagkakataon na makapasok, maaari kang manalo ng isang conference package at gawin ito sa LIVE Grand Finale sa Las Vegas
Alamin paLive connection and DirectQuery comparison
Live connection is a way of connecting a Power BI report to a published Power BI semantic model. DirectQuery is a method you can use to connect your semantic model to data. This article describes the main differences between these concepts.
Live connection is a method that lets you build a report in Power BI Desktop without having to build a semantic model for it. When you create your report in Power BI Desktop, you can connect it to a semantic model that already exists. A live connection allows you to rely on existing data, which can be updated without accessing the report.
Using live connection you can connect your report to one of the following data sources:
A semantic model that already exists in Power BI service
An Azure Analysis Services (AAS) database
An on-premises instance of SQL Server Analysis Services (SSAS)
A Power BI semantic model can have data copied into it during a refresh operation, in what's called import mode. Or, the semantic model can dynamically request data from a data source it's connected to using a method called DirectQuery.
When using DirectQuery, your report uses Data Analysis Expression (DAX) queries to get data. After the semantic model receives the report's DAX query, it generates another set of queries that are run on your data source, to get the required data. If for example your data source is an SQL Server database, Power BI will generate SQL queries to get the data it needs. Other data sources may generate queries in other query languages.
DirectQuery is useful when:
You're working against data sources with a large volume of data
You want to use 'near real-time' data
You can also use DirectQuery with Analysis Services, as described in Using DirectQuery for Power BI semantic models and Analysis Services.
For more information, check out the following resources:
Mga karagdagang mapagkukunan
Pagsasanay
Module
Manage semantic models in Power BI - Training
With Microsoft Power BI, you can use a single semantic model to build many reports. Reduce your administrative overhead even more with scheduled semantic model refreshes and resolving connectivity errors.
Sertipikasyon
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.