Forum Discussion
Publishing reports to automatically refresh
Hello
As a company we are new to PowerBI and I have been tasked with setting up PowerBI reports.
I have managed to set up the report, linking to an excel spreadsheet which pulls the data through when you refresh. We currently have to manually collect the data I need to report on.
I then need the report I have published to automatically refresh - how do I do this? I have also then shared this to the relevant company Sharepoint site page.
At the moment, each day I refresh the report, I have to republish and re embed onto Sharepoint.
Appreciate any hints and tips.
Many thanks
Caitlin
If you have a PowerBI Pro license you can go to PowerBI service.
On PowerBi service you can add a scheduler for auto-refresh
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
But you can only do this if you are a PRO user
In addition to themistoklis's apply,
If you build your report by import connection mode, you can try schedule refresh.
If you build your report by Directquery connection mode, you can try schedule cache refresh, or automatic page refresh in Power BI.
If you build your report by Live Connection mode, you can try schedule cache refresh.
For more details you may refer to blogs as below.
Automatic page refresh in Power BI
To schedule refresh or schedule cache refresh, you need to install a gateway.
Enterprise gateway(works like service) is better than personal gateway(works like application).
Blog: On-premises data gateway vs. on-premises data gateway (personal mode)
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- themistoklis
Community Champion
If you have a PowerBI Pro license you can go to PowerBI service.
On PowerBi service you can add a scheduler for auto-refresh
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
But you can only do this if you are a PRO user
In addition to themistoklis's apply,
If you build your report by import connection mode, you can try schedule refresh.
If you build your report by Directquery connection mode, you can try schedule cache refresh, or automatic page refresh in Power BI.
If you build your report by Live Connection mode, you can try schedule cache refresh.
For more details you may refer to blogs as below.
Automatic page refresh in Power BI
To schedule refresh or schedule cache refresh, you need to install a gateway.
Enterprise gateway(works like service) is better than personal gateway(works like application).
Blog: On-premises data gateway vs. on-premises data gateway (personal mode)
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Rico Zhou