Data Source Link Changing

[DLB13]

Hi all - 

Looking for a bit of help here! I got a power bi file from a colleague to work on today. When trying to edit some queries, I realized that while the data source they linked to was a shared sharepoint excel file, I was not able to access the queries due to it being connected via their computer. What I mean by this is the data source link looked like this:

C:\users\colleague\companysharepoint\clientfolder...

instead of

https://company.sharepoint.com/sites/clientfolder... (which is how I've always linked sharepoint fil...

Since my computer doesn't have their user name, obviously, it cannot find the file. Is there a way to change the source link without messing up the queries or visualizations that have been created? Again, it is the exact same file. Looking forward to your thoughts - many thanks in advance!

[jdbuchanan71]

@DLB13 

In the .pbix go to File > Options and Settings > Data source settings.

In there you can right click on the data source and choose 'Change Source'

Then put in your updated file path that you want to use.

[DLB13]

Thanks for this! I'm not sure this will work for a sharepoint file, though, as I don't put the link to the full sharepoint source in there. I have to put the parent folder as the source, then find the correct file as a part of the query. Again, I can certainly just reconnect everything, but I'm hoping there is an easier way.

[v-lionel-msft · Accepted solution]

Hi @DLB13 ,

Your local .pbix file can not access your colleague's local data source, so you need to change the data source.

Method1:

Let your colleagues upload data source files to the cloud, such as OneDrive for business, SharePoint online...
Method2:

Copy the local data source file of your colleague to your local and change the data source like @jdbuchanan71  said.

Or you can collaborate in Power BI Service, but you can not model in PBI Service.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.