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
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
6 years ago

Hi,

I had the same issue before when trying to change the source of the data. You need to open Power Query in power bi desktop and check if the source of the table is alos changed. Sometimes the change does not take effect until you changed in power query.

 

I am using a web source and local source for my report: 

https://app.powerbi.com/view?r=eyJrIjoiMjc2N2ZkZmYtMTNjYi00N2Q0LWE4MmUtYjhiY2E4NTQxZGM1IiwidCI6IjgzNTU5ODFiLTJlYTYtNDdjZi04ZjJiLTc3MTY3N2FmZjMyZCJ9