Forum Discussion

jmb's avatar
jmb
Regular Visitor
7 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    stribor45
    Post Prodigy
    1 year ago

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