Forum Discussion
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...
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)
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)
This worked. Thank you!
