Power BI Data Refresh Issue

[Anonymous]

Dear Everyone,

I made a report on Power BI where there are multiple data sources being used, out of 4 of them were the Dynamics Finance & Operations URLs. I did all the work on the UAT URLs, after completing the report, i changed the data source of the ERP environment and changed it to LIVE. After the refresh got completed, most of the columns in the report got empty. I went to see and there was also data, but what i noticed was that the measures were not bringing the values, although the relevant data was available.

Please help.

[Anonymous]

@Anonymous 

When one of your data sources is in Live Connection mode, you can no longer merge data from multiple data sources, and it is limited to the one data source/database you selected, so the table data of your other data sources will be invalid.

This is about the restrictions and content of Live Connection mode:

https://community.powerbi.com/t5/Community-Blog/Power-BI-Live-connection-vs-Import-comparison-and-limitations/ba-p/84377

https://radacad.com/live-connection-when-power-bi-comes-hybrid

https://xxlbi.com/blog/switching-from-imported-data-to-directquery-or-live-connection-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.

[lbendlin]

If you change data sources in Power Query and the resulting table structure differs from the prior result then your measures, groupings, sort settings etc can be severely impacted or even destroyed.  You have to make double and triple sure that the structure matches.

You may want to evaluate the use of deployment pipelines.