Forum Discussion

DLB13's avatar
DLB13
Helper I
6 years ago
Solved

Data Source Link Changing

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 sha...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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.

DLB13's avatar
DLB13
Helper I
6 years ago

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's avatar
v-lionel-msft
Community Support
6 years ago

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.