Forum Discussion
Queries created in Power Query are not updating with changes made in Dynamics 365 Tables
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.
Hello Anonymous,
Yes exactly. Here is the image:
The Highlighted ActiveBacklogs, ActivePipelines, and Cashflows are straight from Dynamics 365.
ActiveCashflows and Consolidated are created as blank queries but from the data of the 3 tables above. Consolidated is the one used in my graphs since it joins ActiveBacklogs, ActivePipelines, and ActiveCashflows.
Best regards,
Joseph
Hi joseph_Dev ,
Now that you have confirmed that my understanding is correct, I have performed an actual test based on your situation. And I have confirmed that if your data table was created in Power Query using Blank Query, it still cannot be updated in Power BI Service even if the data in that table comes from the other three tables you have connected from Dynamics 365.
This is because the data source for these two data tables is Power Query itself and not your original data source. This means that the process of updating these two data tables can only be done locally and there is no way to pass it on to Power BI Service. So I'm sorry to tell you that you can only update these two reports by updating them locally and then republishing them.
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.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.