How to change the source from onedrive personal to one drive for business

[Anonymous]

Hello,

My company has recently purchased power BI pro and also the full microsoft for Business package. This means I have had to move my spreadsheet of data from a 'personal' one drive to onedrive for business. 

I can't seem to sucessfully change the source on my power BI deskptop file to the new one drive for business location. When I edit the source to include the link to the one drive for business excel file, it doesn't. Can anyone help me with this? 

Thanks in advance! 

Grace

[Anonymous · Accepted solution]

HI @Anonymous,

I'd like to suggest you refer to the following link to change your data source steps to use a web connector to work with onedrive for business file link:

Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs

Notice:
You need to confirm these file has the same data structure or it will show the error message for the data key not matching. You also need to publish the report file to replace the old version report.

Regards,

Xiaoxin Sheng

[Anonymous]

Thank you for your reply

[amitchandak]

@Anonymous , Create a new connection with a new source with one drive business.

Go to power query, Right-click on a table, and open advance editor.

Copy a few lines of code and carefully change the code in the old table (usually first few lines)

Make sure the next step table is corrected

Few steps discussed here

How to Change Connection Details https://www.youtube.com/watch?v=59PUFuuCrbY