Change data source

[Anonymous]

Morning,

I have an issue about data source changing.

I have change data source from local to sharepoint via advance editor and it work properly but in data source parameter, the other local source stay available and when someone want to update or refresh an error occur cause report steal linked to loacl data source.

How can I fix this issue ?

Please need your help !

Thanks

[mohammedadnant]

Hi @Anonymous 

Make sure you are using the web link of the SharePoint,

after replacing the data source --> close and apply in Power query --> check it load and try refreshing manually in Power BI Desktop.

if all ok then publish into Power B service.

it will work.

[Anonymous]

Hi @mohammedadnant ,

As you can see below the data source is web link (from sharepoint)

I don't know if it's the same like web

[Anonymous]

My main issue is to others people refresh or update the report.

Is it possible without premium licence ?

I have design a dashboard from local folder and after change folder to sharepoint to permit my collegues to update report.

When I use, it work properly but when my collegues refresh, it say that it can access to my local file that i already move to sharepoint.

[mohammedadnant]

@Anonymous 

I believe your colleagues also have access to the same SharePoint folder.

as per your message "It can't access the local file" means still some table(s) are connected to your local drive.