Forum Discussion

GiantsFan1989's avatar
GiantsFan1989
Frequent Visitor
1 year ago
Solved

PowerBI Semantics Model - Error When Refreshing

Hi All,   I am new to PowerBI and, for the most part, self taught.  I have created a few reports in the PowerBI App and published the reports to my personal workspace to test functionality.  When I...
  • danextian's avatar
    1 year ago

    Hi GiantsFan1989 

    Based on the first screenshot, Power BI is connected to the local copy of the file stored in SharePoint. You will need to connect to the version stored in SharePoint and then republish the pbix.  You will need to change your Source applied step from

    Excel.Workbook(File.Contents("localpath.xlsx"), null, true)

    to

    Excel.Workbook(Web.Contents("sharepointpath.xlsx"), null, true)