Showing results for 
Search instead for 
Did you mean: 

New Change Detection + Direct Query BW?

Does this work?   We have several virtual cubes with queries pulling realtime data into BW.  I setup a direct query and can see data, but cannot get the Change Detection to launch the setup window and the ribbon button stays grey.  clicking Change detection on a measure  or report formatting tab does nothing.  Setting a time interval works, but I was hoping to tie this to real new sales coming in..   





Community Support
Community Support

Hi, @james_batchelor 


About DirectQuery connections, during the initial Get Data experience, the source is selected. For relational sources, a set of tables are selected and each still define a query that logically returns a set of data. For multidimensional sources, like SAP BW, only the source is selected.


No data is imported into the Power BI store upon load. Instead, upon building a visual within Power BI Desktop, queries are sent to the underlying data source to retrieve the necessary data. The time taken to refresh the visual depends on the performance of the underlying data source.


Any changes to the underlying data aren't immediately reflected in any existing visuals. It's still necessary to refresh. The necessary queries are resent for each visual, and the visual is updated as necessary. Addtionally, you may also refer Automatic page refresh in Power BI Desktop .


For further information, please refer About using DirectQuery in Power BI .


Best Regards



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



Super User
Super User

@james_batchelor , Refer his link , there is some ongoing discussion on that

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

thx.   but specifically it seems a direct BW query does not allow setting up Change detection.  I can click on the menu items but the setup window never appears.  Not a real issue.. I can run by time.. but was curious to see how this feature works.



Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors