Forum Discussion
direct query vs. import
ammartino44This page will help. But essentially here are the basics
Import - extracts the data from your database and pulls it into the Power BI Desktop
Direct Query - leaves the data in the database and sends queries to pull the information needed.
Other things to note:
Import -
Gives you the full suite of transformation and data manipulation in the Desktop
There is a 1 GB limit to the Desktop if you plan on publishing to the PBI Service
Consumes and pushes the data into the Power BI Azure backend (Azure DB/Blob Storage) (In the Service)
Can only be refreshed up to 8x a day by setting up a scheduled refresh (In the Service)
Direct Query -
Limits your ability to manipulate data in the Desktop (removes the Data section)
Leaves the data in the SQL database
Is "live", no need to schedule a refresh (In the Service)
Both methods require a gateway to be installed, unless you are talking about Azure SQL.
wmorris20 That makes sense to me... It pulls back the different objects and allows you to do the filtering on the Report side. If it didn't do that, then it would have to understand the filter context of everything on your report, in your measures, etc. Will it generate an aggregate value if you create a measure summing up the sales of something? Or will that just query all sales?. I should probalby dig into testing this out to determine what is happening.