Best Practice for Direct Query

[Anonymous]

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?

[v-huizhn-msft · Accepted 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