Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
benz-fsproduce
Frequent Visitor

Sharing Power Bi Template

Hi, I am trying to share the template I created with my coworker. I saved the report to onedrive, but my coworker keeps getting the same message. Thanks.

benzfsproduce_0-1659549401728.png

 

1 ACCEPTED SOLUTION
AlexanderPrime
Solution Supplier
Solution Supplier

This is because your data source is stored locally on your PC, When browsing for an excel file to get data from, it'll open up windows explorer which technically is your locally stored versions rather than the cloud, hence why you are getting a path of "C:\Users\{yourusername}" in your error message. And when your coworker is trying to refresh, it's trying to read your C drive folder for the file which of course due to security it cannot do. 

 

You'll need to connect to Excel files in OneDrive in this method for it to work. 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

 

Alternatively if you store the file on a Teams/SharePoint channel. You'll need to connect via "Sharepoint Online Folder" to get to the Excel file so your co-worker can access it.

 

https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/

 

 

You should be able to change the current report by changing the data source location, this has a few steps but this guide covers it well. https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/


Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy doin' Data Science.

If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!

View solution in original post

1 REPLY 1
AlexanderPrime
Solution Supplier
Solution Supplier

This is because your data source is stored locally on your PC, When browsing for an excel file to get data from, it'll open up windows explorer which technically is your locally stored versions rather than the cloud, hence why you are getting a path of "C:\Users\{yourusername}" in your error message. And when your coworker is trying to refresh, it's trying to read your C drive folder for the file which of course due to security it cannot do. 

 

You'll need to connect to Excel files in OneDrive in this method for it to work. 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

 

Alternatively if you store the file on a Teams/SharePoint channel. You'll need to connect via "Sharepoint Online Folder" to get to the Excel file so your co-worker can access it.

 

https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/

 

 

You should be able to change the current report by changing the data source location, this has a few steps but this guide covers it well. https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/


Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy doin' Data Science.

If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors