Change Data Source Location (excel, onedrive)

[jmb]

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

[Anonymous · Accepted solution]

@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

[stribor45]

I 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],