Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
What is the best practice for using direct query,
We are querying against a live sales databse, and the performance is not very good. I am currently using date wheres in the SQl and in the Report via slicers. For direct query is it just as well only using the slicers?
Solved! Go to Solution.
Hi @Anonymous,
With Power BI Desktop, when you connect to your data source with import mode, it is a copy of the data into the Power BI Desktop. DirectQuery – no data is imported or copied into Power BI Desktop. As you create or interact with a visualization, you’re always viewing current data. DirectQuery lets you build visualizations over very large datasets, and you always use the current data, not need to re-importing data and refresh when the data is updated.
When you upload the data to Power BI desktop, you can use SQL in Advanced Options to filter the data. While, A slicer narrows the portion of the dataset shown in the other visualizations on the page. Direct Query is a database mode, slicer is a visualization level filter.
Best Regards,
Angelia
Hi @Anonymous,
With Power BI Desktop, when you connect to your data source with import mode, it is a copy of the data into the Power BI Desktop. DirectQuery – no data is imported or copied into Power BI Desktop. As you create or interact with a visualization, you’re always viewing current data. DirectQuery lets you build visualizations over very large datasets, and you always use the current data, not need to re-importing data and refresh when the data is updated.
When you upload the data to Power BI desktop, you can use SQL in Advanced Options to filter the data. While, A slicer narrows the portion of the dataset shown in the other visualizations on the page. Direct Query is a database mode, slicer is a visualization level filter.
Best Regards,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |