Forum Discussion
Change Data Source Location (excel, onedrive)
Hi,
I'm using Powerbi on line (PBI service). I do have a report working from a data source I created from an excel file stored on my team's sharepoint / onedrive. The excel file has been imported as a data set (not a workbook). I use the simple and automatic refresh offered by onedrive.
I need to move this file into a sub folder (same sharepoint site).
Where and how can I change my report to have it working with the new file without redoing it again ... ?
Regards
JM
jmb,
It is not possible to change data source location for the existing report in Power BI Service.
In your scenario, after you move the file into a sub folder in sharepoint site, please re-connect to the file in Power BI Service, then create a empty report and move visuals from original report to this newly created report. For more details, please review the following blog:
https://powerbi.tips/2018/01/move-visuals-between-reports/
Regards,
Lydia
2 Replies
jmb,
It is not possible to change data source location for the existing report in Power BI Service.
In your scenario, after you move the file into a sub folder in sharepoint site, please re-connect to the file in Power BI Service, then create a empty report and move visuals from original report to this newly created report. For more details, please review the following blog:
https://powerbi.tips/2018/01/move-visuals-between-reports/
Regards,
LydiaI dont know what you mean about subfolders but i resolved it by using web.contents
Source = Excel.Workbook(Web.Contents("https://........./Names.xlsx"), null, true), sheet1_Sheet = Source{[Item="sheet1",Kind="Sheet"]}[Data],
