Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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.
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 @amitchandak .
I'll try again with the same password.
When the form indicate "Identification Windows" that mean I have simply use the name of my session Windows where the files are save (Jules Poujol for my exemple) or I have to put something before (Domain\Jules Poujol for example) ?
Is it possible to use a "LiveConnect" with my excel file save on my One Drive entreprise ?
Have a nice day !
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.
@julespoujol , refer if this can help
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |