Solved: Azure SQL only refreshed in powerbi desktop app

aadilganie · ‎04-19-2020

Hi!

I have a created a very simple report that counts users in one table from a database in Azure SQL. I have published the report and when clicking refresh in my browser nothing happens, but from PowerBI desktop it seems to pick up new entries.

Is there something specific im missing out on? I used the DirectQuery method of GetData.

Thanks!

nandukrishnavs · ‎04-19-2020

@aadilganie - If you are using DirectQuery mode, Power BI will fetch the data directly from DB only.

To view the changes immediately, you can click on the "refresh" button.

Otherwise, you will see cached data. If you pin a visual into the dashboard, you can view the changes immediately without refreshing.

Also, you can check the preview feature automatic page refresh. https://docs.microsoft.com/en-us/power-bi/desktop-automatic-page-refresh

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

Regards,
Nandu Krishna

View solution in original post

nandukrishnavs · ‎04-19-2020

@aadilganie - If you are using DirectQuery mode, Power BI will fetch the data directly from DB only.

To view the changes immediately, you can click on the "refresh" button.

Otherwise, you will see cached data. If you pin a visual into the dashboard, you can view the changes immediately without refreshing.

Also, you can check the preview feature automatic page refresh. https://docs.microsoft.com/en-us/power-bi/desktop-automatic-page-refresh

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

Regards,
Nandu Krishna