Forum Discussion

Jeremy19's avatar
Jeremy19
Icon for Helper III rankHelper III
2 years ago
Solved

How to refresh report in real time

Hello, I would like to understand more about updating report. I have a practical case where my Power bi is linked to an Excel data source, all stored on Sharepoint Online. The Excel data is updated ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    You would need a Direct Query data source and APR (automatic Page Refresh)  enabled in your tenant.  

     

    Instead, consider using a push dataset and a dashboard.

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

You would need a Direct Query data source and APR (automatic Page Refresh)  enabled in your tenant.  

 

Instead, consider using a push dataset and a dashboard.

Jeremy19's avatar
Jeremy19
Icon for Helper III rankHelper III
2 years ago

So it's impossible to use an Excel source?

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

    pretty much.  Excel is a Import mode source, and even if you are on a Premium Capacity with unlimited daily refreshes  it is still not a feasible setup. I mean, you could push it to work but the effort to result ratio will be miserable.