PowerBI Semantics Model - Error When Refreshing

[GiantsFan1989]

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

[danextian · Accepted solution]

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)

[GiantsFan1989]

This worked.  Thank you!

[MasonMA]

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. 

[GiantsFan1989]

I may have to get my data analytics or IT team involved.  Is that on the desktop site?

[MasonMA]

Desktop site? Admin/IT may configure this on their Azure Portal, but for me it's in the setting of my semantic model:) 

[MasonMA]

@GiantsFan1989 

You may change the Credential type under 'Edit Permission' to 'Organizational Account' and give it another try.

[GiantsFan1989]

Switched, re-published the report, same result unfortunately.