Forum Discussion

joseph_Dev's avatar
joseph_Dev
Frequent Visitor
2 years ago
Solved

Queries created in Power Query are not updating with changes made in Dynamics 365 Tables

Hello community,   In Power BI Desktop, I've created a report using Dynamics 365 Sales as my data source. I connected it via DirectQuery Mode. The report contains three queries sourced directly fr...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • joseph_Dev's avatar
    joseph_Dev
    2 years ago

    Hello Anonymous,

    Thank you for elaborating. So basically changes made in new tables created within power query but not in dataverse do not show in the graphs of these tables.

    Since seeing live changes on graphs related to cashflows is a necessary requirement by top management, I made something a little bit redundant but necessary: In my dataverse table, I basically created the columns that are supposed to be fields in the related tables, and used Power Automate to populate them. Now, despite being redundant, my dataverse table has all the fields required in the graphs and changes are being reflected live. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi joseph_Dev ,

If I understand you correctly, your two reports were created directly in Power Query via Blank Query, so the data source for these two reports is itself and not related to Dynamics 365. In Power BI Service, you can't make such a report refresh in real time because it doesn't connect to the original data source, and the only way for you to refresh the report is to re-upload it after updating it on Power BI Desktop.

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