Configuring auto refresh for a file shared through One Drive

[kkalyanrr]

Hello ,

I'm trying scdule refresh a csv file which in my folder. I could able to do refreshes using personal gateway but when I try to use standard gateway which is sitting in server machine..its throwing error saying Credentials wrong.

Any advise.

[v-juanli-msft]

Hi @kkalyanrr 

It won't work for gateway if it is installed in a DC controller.

What do you mean by "which is sitting in server machine"?

Best Regards

Maggie

[Anonymous]

Is the CSV on your personal One Drive? Then you can use the web connector in PBI Desktop. Copy the file path to the CSV. Something like below

https://yourcompany-my.sharepoint.com/personal/firstname_familyname_yourcompany/Documents/yourcsv.cs...

When you publish the report you will see that you don't need a gateway, but you will need to enter your credentials.

[amitchandak]

@kkalyanrr , refer if this can help

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot