Forum Discussion

OZMckenzie's avatar
OZMckenzie
Icon for Helper I rankHelper I
6 years ago
Solved

Changing data source from local drive to Sharepoint file -PBI service refresh failed

Hello,   I have changed the data sources of one PBI report from excel files at local drive to files on sharepoint. I did the change by replacing the file path URL. I can do refresh on PBI desktop, ...
Need Help
OZMckenzie's avatar
OZMckenzie
Icon for Helper I rankHelper I
6 years ago

Hi amitchandak, aj1973 , v-diye-msft ,

 

Thank you all for great advice! 

amitchandak, I did read the article before posting this inquiry, the mistake I made was copying the link in an incorrect way. I copied the link without opening the file in Excel apps. I can do PBI desktop refresh but unable to refresh the PBI service due to data credential.

 

By using the correct path, I am able to choose "OAuth2" to configure the data source for PBI service.

 

 

the URL I got by clicking "copy link" on sharepoint excel:
https://***.sharepoint.com/:x:/r/teams/****-***%20new%20data.xlsx?d=w0039779bb38845af9928d19b4eead043&csf=1&web=1&e=uqds4b

 

the URL I got by opening the file in excel apps and copy path in the Info page:
https://***.sharepoint.com/teams/****-***%20new%20data.xlsx?web=1

 

 

Thank you all again!