Configuring auto refresh for a file shared through One Drive

[kkalyanrr]

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.

[v-easonf-msft]

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.

[kkalyanrr]

@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..

[v-easonf-msft · Accepted solution]

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.