Forum Discussion
refresh automatically published report
Hi all,
Is it possible to automatically refresh the publication as soon as a data is updated?
To be more precise, in PowerBI Desktop, I have a database that I update.
I would like the published report to be updated automatically without having to click on the "Publish" button in PowerBI Desktop again.
Thank you very much.
Jules
Hi julespoujol ,
If the source datasets come from SharePoint and onedrive, there is no need to configure the gateway, just set the credentials and set the schedule refresh.
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
Hi julespoujol
You can schedule refresh in the service, use Power Automate, Power shell or Automatic Page refresh, please see the links below.
https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedInjulespoujol , refer if this can help
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
Hi julespoujol ,
You need to confirm what the connection is.
Refer to:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
After that, you need to install the appropriate version of the gateway.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
You can also learn about this API
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refreshdataset
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi all,
Thank you very much V-lianl-msft amitchandak Mariusz but it's not working 😞
To be more precise :
1 - I create a dashboard on PowerBI Desktop with 2 kinds of data base :
- One excel file on my Onedrive (entreprise)
- One list on sharepoint
2 - I install Gateway on premise and everything looks find
3 - I update my gateway on powerBI service (I mean on the website)
4 - I click to add my databse
5 - The warning message appear :
I copy the missing part
Test_4: Informations d'identification de connexion non valides.
Code d'erreur sous-jacent: -2147467259
Message d'erreur sous-jacent: Les informations d'identification fournies pour la source SharePoint ne sont pas valides.
Which identifiant i have to use ? My email adress Sharepoint and Onedrive Entrprise ?
Morever, how can i update automatically my dashboard on powerBI destkop whitout cliking on the button "Update" ? ( I mean, when i update my excel file on Onedrive, the dashbaord change instantly and automatically)
Thank your very much
PS : Sorry, the screenshot is on French language, but i can translate if you needed
Jules
Which identifiant i have to use ? My email adress Sharepoint and Onedrive Entrprise ?
What ever you have used in desktop for development. Same need to be used in power BI.
Update without button. As far as know there only option for Live or direct not for import mode.
Mariusz , looking forward for your update.
thank you V-lianl-msft
