Forum Discussion

karimabdelrazek's avatar
karimabdelrazek
Frequent Visitor
2 years ago
Solved

Merged queries instant update in PowerBI Service?

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

Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    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.

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    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.