Hello Power BI Community,
I am having a Power BI Service dataset refresh failure.
I receive the following summary error: Data source error<pii>The credentials provided for the Web source are invalid. ...
I am loading in an Excel file that sits on a SharePoint site via Source = Excel.Workbook(Web.Contents("https:// ...
Under a Power BI Desktop configuration, using an Organizational Account (which is displayed), the refresh is successful.
When the PBIX file is pushed to Power BI Service and a refresh is triggered, the refresh fails.
When investigating credential configuration for the web connector, the service only displays/allows the Anonymous or Basic Authentication method.
My assumption is that because the Power BI Service is not using the PBIX file's Organizational Account config, the refresh fails.
Suggestions?
Best regards,
Mark
------------------------------
Mark Wheeler
R&D Portfolio Analyst
------------------------------