Direct Query DAX Table Refresh

[Anonymous]

Hi,

I am having a problem with a Direct Query report i have authored and published to powerbi service.

I have two measures in the report:

• Measure 1 - Count() of items in MS SQL table directly
• Measure 2 - Calulcate(Count(),filter) of items in a DAX table withing the report that is made using SummarizeColumns() to summarize the MS SQL table  

When I add new items to the MS SQL table this is the behavior i get:

• PowerBI desktop - Both Measures update flawlessly upon pressing refresh button
• PowerBI Service - When i refresh the browser, Meaure 1 updates, but Measure 2 does not. If i go in and manually refresh the dataset from the service or wait for the next sechduled refresh, Measure 2 will update as well.

It is acting as if the DAX table does not refresh until the dataset is refreshed. Why is this?

With Direct Querry shouldnt everything in the report, DAX calulations and tables inlcuded, refresh everytime the report/browser is refreshed?

Why is there even an option to refresh the dataset? Shouldn't the dataset be refreshed everytime the broswer/report is refreshed? Isnt that the point of Direct Query?

Please help me with my igonorance!

 -Alex

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

For DirectQuery mode, there is no any data included in the dataset on Power BI service, but a direct connection between Power BI and the database. When you interact with a visualization, queries are sent from Power BI directly to the database, and query results will be updated on the visualization.

To enhance the performance, dashboard tiles are cached and periodically refreshed. When a cache refresh happens, queries will be resent from Power BI directly to the database again for all visualizations/tiles, and query results will be updated on all the visualizations.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nickyvv]

Could you first clarify if you mean Scheduled Refresh (for Import) or Cache Refresh (for DirectQuery)?

Because if you have Scheduled Refresh available then I assume you are using Import somewhere in your model.

In addition to that, can you share the measures you are using? Or even better, the pbix if there's no private data in it?