Portland Power Platform User Group

Please login or click SIGN UP FOR FREE to create your PowerPlatformUG account to join this user group.

Power BI Service refresh issue due to (misconfigure credential) credential authentication failure

  • 1.  Power BI Service refresh issue due to (misconfigure credential) credential authentication failure

    Posted Oct 29, 2020 05:04 PM
    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
    ------------------------------