onedrive for business folder and an existing power bi report

[avitalo1]

 Hi,

I have a report created on PowerBi desktop with the source folders on my local drive.

After I created the report I moved the folders to onedrive.

How can I fix the M so that I can use the onedrive folders in the cloud (and not have to change all the sources each time I open the report on a different computer).

If this cannot be done, what is the best way to connect to the folders and rebuild my report?

thanks

Avital 

[Mariusz]

Hi @avitalo1 

If you cannet to this file/folder in one drive you can later copy all the steps from your previous query using Advanced Editor ( usually everything after Changed Type should be ok ) and later paste into the advanced editor of this new query after Changed Type.

As you connect to the same file, only the first few steps should be different as different functions are used to connect to different data sources or storages.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[avitalo1]

Thanks. Can you recommend a good tutorial for connecting to the onedrive and for copying the steps?
I would still love to find a solution that wouldn't require building a new report. 

[mahoneypat · Accepted solution]

You don't have to build a new report.  Here is a recent video that shows how to get data from a OneDrive file using the SharePoint Folder connector.  Just build the new query, and then copy the steps of the new query and replace the Source (and maybe a few more steps) of your existing query.  You may have to update your step references so the each step references the table/variable before it (e.g., #"Changed Type").  WIth this approach, your original table will stay in the model with all the relationships, measures, visuals, etc. still intact.

https://www.youtube.com/watch?v=cxRacjMb47I

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[avitalo1]

Thanks. Had to fiddle with the existing code, mainly changing the parameter numbers, but finally managed to get this to work.

Will be much smarter about the next report.

Thank you again for the help

Avital