Forum Discussion
Configuring auto refresh for a file shared through One Drive
Hello Team
I've a dashboard runs on data from One Drive, I could able to refresh the data using personal gateway .
But when I try to schedule refresh using Online gateway(installed on server) its throwing the following error.
Any help.
Hi , kkalyanrr
Obviously the credential that you provide is local credential and the url is not the one that on the onedrive.( the url should be "https:xxxxxx.sharepoint.com.xxx" instead of "c\\user.......")
In addition ,it is suggest to connected to the one drive file from desktop using web instead of share point folder .
Please follow these steps:
1.open the csv file in onedrive by using desktop excel app, then copy the path info of your excel .2.connected to the one drive file from desktop using web ( need Remove the ?web=1 string at the end of the link)
3.sign in your account
4.the result will show as below
For more details ,please refer to this document.
desktop-use-onedrive-business-links
You also can refer to this post.
https://community.powerbi.com/t5/Power-Query/Get-csv-file-from-OneDrive-and-auto-update/m-p/431605
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi, kkalyanrr
I can't see the error message on the right half from your first screenshot.
BIteam: invalid connection credentials????? Underlying error message: The crendentials ??????? Can you provide a good screenshot (masking some of your sensitive information)?
Is this your error Details?
Details: "We could not register this data source for all gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."
And it seems that you connect csv files stored on OneDrive to Power BI Desktop via Web connector, then publish the pbix file to Power BI Service, right?
Please refer to desktop-use-onedrive-business-links to get the correct web url and make sure you select OAuth2 as the Authentication method when configuring your refresh settings.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.v-easonf-msft
Hi,
I've connected to the one drive folder from desktop using share point folder instead of web as shown in the pic..Hi , kkalyanrr
Obviously the credential that you provide is local credential and the url is not the one that on the onedrive.( the url should be "https:xxxxxx.sharepoint.com.xxx" instead of "c\\user.......")
In addition ,it is suggest to connected to the one drive file from desktop using web instead of share point folder .
Please follow these steps:
1.open the csv file in onedrive by using desktop excel app, then copy the path info of your excel .2.connected to the one drive file from desktop using web ( need Remove the ?web=1 string at the end of the link)
3.sign in your account
4.the result will show as below
For more details ,please refer to this document.
desktop-use-onedrive-business-links
You also can refer to this post.
https://community.powerbi.com/t5/Power-Query/Get-csv-file-from-OneDrive-and-auto-update/m-p/431605
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
