Forum Discussion
refresh automatically published report
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.
Community SupportHi 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
- amitchandak
Super User
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
