Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0

Powerbi Direct Query and Cached Data issue

We are working on a powerbi report which has a slicer apply button and when the slicer is applied , it does call a oracle stored proc (with a writeback) in one of the tables and fetch the latest result using direct query. once the results are displayed in a tabular format, when the user hits back button and choose the value from the slicer again to go back to writeback page, the data is taken from the cache and as a result even in teh writeback page, the direct query is not executed but takes the values from the cache which is not what we want. we want the latest values to be displayed by executing the direct query. we have tried few ideas in teh community like RAND function, cache settings both in the desktop and the powerbi service. we cant get this to work and its frustating. 

 

any ideas pls ?

Status: Delivered

Hi @power2kp 

It depends on the way you connect to the data source.

If you are using Direct Query and Live Connection connection modes, then when you interact or query in the Service, the corresponding query is sent to the data source and the latest results are returned. If you are using Import connection mode, then the previous cache is queried.  

So if you want to return up-to-date data, you can choose to connect to the data source using Direct Query or Live Connection connection mode. For more details you can refer to the official documentation below.

Data refresh in Power BI - Power BI | Microsoft Learn

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Delivered

Hi @power2kp 

It depends on the way you connect to the data source.

If you are using Direct Query and Live Connection connection modes, then when you interact or query in the Service, the corresponding query is sent to the data source and the latest results are returned. If you are using Import connection mode, then the previous cache is queried.  

So if you want to return up-to-date data, you can choose to connect to the data source using Direct Query or Live Connection connection mode. For more details you can refer to the official documentation below.

Data refresh in Power BI - Power BI | Microsoft Learn

 

Best Regards,
Community Support Team _ Ailsa Tao