Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

PowerBI Embedded direct query caching

Hi all,   As the title suggests, we use PowerBI Embedded in direct query mode.  I'm finding that the data is cached.  We have data updates happening every minute in the database.  We can't get the ...
Need Help
Tips and Tricks
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago
Anonymous wrote:

Hi all,

 

As the title suggests, we use PowerBI Embedded in direct query mode.  I'm finding that the data is cached.  We have data updates happening every minute in the database.  We can't get the report to show the latest data.   It seems to be possible to set the caching strategy on the O365 offering - but I don't think this is possible in PowerBI Embedded.

 

Has anyone else found this?  Do you have a solution?  Some kind of Data Refresh button would be ideal.  Can this be spoofed with a slicer and some clever DAX?

 

Regards chaps 

Nick

Anonymous

The only cache regarding DirectQuery that I'm aware is  Custom Cache Refresh Schedules in the Power BI Service. However that cache won't affect the data updating, every time some accesses the report in DirectQuery mode, Power BI just sends query and retrieve latest data. 

 

The cache in Power BI Embedded is for import mode, see Cached datasets. As to DirectQuery, I don't see any cache machinism.

May I know how did you observe that "the report won't show latest data"? Based on my test, when data updated in my azure sql database, after refresh the embedded report shows the latest data.