Forum Discussion
Move folder of data scources.
I have created a dashboard that I would like to move the folder which contains the excel report spreadsheets that link to the dashboard. Is there a quick way to move the folder so all of the links, relationships etc will still work?
Hi Anonymous
Try this,
(1) Download the .pbix file from Service,
(2) then go to Power Query Editor, change the datasource code in Advanced Editor to the new path
(3) check the columns in Excel and keep them unchanged. If you want to change the column in excel, modify the column name code in Advanced Editor
(4) republish the .pbix file to Service.
(5) If you set a schedule refresh on that dataset, go to Data Source Settings on Power BI Service and update the information.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
v-xiaotangCommunity Support
Hi Anonymous
Try this,
(1) Download the .pbix file from Service,
(2) then go to Power Query Editor, change the datasource code in Advanced Editor to the new path
(3) check the columns in Excel and keep them unchanged. If you want to change the column in excel, modify the column name code in Advanced Editor
(4) republish the .pbix file to Service.
(5) If you set a schedule refresh on that dataset, go to Data Source Settings on Power BI Service and update the information.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.