Forum Discussion
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 try to refresh the data (the data is held on a company SharePoint) from the semantics model, I get the following error message each time - "Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh."
When I click on the Semantics Model settings and go to the Data Source Credentials, it is greyed out. I am attaching a bunch of screenshots to show you the data source settings in my .pbix file and the connections page on the Desktop site.
Is this a permissions problem? Is it an issue with the path name?
SharePoint Excel File .pbix permissionsConnection errorSharePoint website .pbix permissionsSemantics Model Data source connection greyed outConnections settings greyed out
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)
7 Replies
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!
You may change the Credential type under 'Edit Permission' to 'Organizational Account' and give it another try.
Switched, re-published the report, same result unfortunately.
Weird. This is usually how i set it up below, but for gateway etc. we have platform team and it's usually their responsibility to configure them.
I may have to get my data analytics or IT team involved. Is that on the desktop site?
Desktop site? Admin/IT may configure this on their Azure Portal, but for me it's in the setting of my semantic model:)
