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
jagostinhoCT
Post Partisan
Post Partisan

migrate from local to one drive for business

Hello,

 

I started a pbix file linking it to some local files (XLS, CSV) and have created lots of Queries, reports and visuals using them.

 

I would like now to upload them all into the One Drive for Business so that they can be edited by other people at the office but would not like to loose all work done so far.

 

The files are to be exactly the same. It would only be the Source that will change.

 

I already found how to Get Data from within Power BI Web and link to those files. But not for Power BI Desktop.

 

Is there an easy and safe way to do this?

 

Thank you for your help.

Joaquim

1 REPLY 1
zrichardson
Advocate I
Advocate I

What I did is I started to create a new report in Power BI Desktop. I connected it to the OneDrive Files that I needed for the report. Then I edited the query, right clicked the table, and clicked advanced editor. I then copied the source from this new report and pasted it as the source for the report that I had already created using local files. This let me change it to a OneDrive file, however, it is not an in-sync file like it should be when it is a OneDrive source because you have to create the report on Power BI Online. I haven't figured out what the source line would be for a datasource created in Power BI Online. If anyone else has a suggestion let me know.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors