Merged queries instant update in PowerBI Service?

[karimabdelrazek]

Hi All,

Total newbie here. In PowerBI Desktop, I merged two Dataverse tables "TableA" and "TableB" into a new one called "TableC". My report contains an embedded PowerApp that allows the user to make updates to TableA and TableB. The PowerApp command ends with the "PowerBIIntegration.Refresh()" to ensure the data in both tables in PowerBI are updated.

When I test the report in PowerBI service, I don't see the data in "TableC" instaneously. I'm on a Premium license, so I'm presuming I shouldn't have any issues with instant data refresh. Can anyone help me sort this out?

Thanks!!

Karim

[lbendlin · Accepted solution]

This setup will only work when your tables are accessed in Direct Query mode. It will not work in Import Mode.

 I merged two Dataverse tables "TableA" and "TableB" into a new one called "TableC"

Please don't.  Let the data model do the work for you if possible.