Forum Discussion

aadilganie's avatar
aadilganie
Regular Visitor
6 years ago
Solved

Azure SQL only refreshed in powerbi desktop app

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!

Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    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     🙂

     

     

1 Reply

  • nandukrishnavs's avatar
    nandukrishnavs
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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     🙂