Credentials provided for the Web source are invalid – PowerBI

Excel file in OneDrive as source for PowerBI report is a very common scenario. If you want to use an Excel file as a data source for your PowerBI report, what better place to store it rather than OneDrive or SharePoint.

Here is an issue I ran into, cannot refresh the report after publishing it to PowerBI service. It kept on failing with below error:

“The credentials provided for the Web source are invalid. (Source – Excel location in OneDrive)”

As a matter of fact, I right away knew something is wrong because when I try to Edit credentials, OAuth option is not available for authentication. Only Basic and Anonymous are available options in drop down.

I made sure I copied the correct link to Excel file by opening it in browser copying the link instead of generating a share link. I have removed ?web=1 from the URL. In my report, added the source as a ‘Web’ source instead of Excel. Authentication in PowerBI Desktop is setup using Organizational account. Deleted the data source in PowerBI service and republished it. Created it from scratch again but still ‘OAuth’ Authentication option doesn’t show up in PowerBI service.

Resolution:

Noticed after closely observing the error (above image) again, since the URL was copied from browser, it included the ‘/:x/r/‘ which Microsoft adds by default for browser compatibility. Updated the source URL and removed ‘/:x/r/‘ string from URL. Published it again to PowerBI service.

Problem Solved! This time, I see ‘OAuth’ as an Authentication option and refresh works as expected.

Hope it helps someone. DO NOT include ‘/:x/r/‘ string in source URL.

8 thoughts on “Credentials provided for the Web source are invalid – PowerBI

  1. Thank you so much, it solved my issue as well.
    Now Refresh is also working fine,Really helpful stuff.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

PowerBI visualization for SharePoint Document libraries

Visualization of SharePoint list data as a PowerBI report is already available with few button clicks. This awesome functionality is now extended to Document libraries in SharePoint.  How cool is that! Business users do not have to rely on admins to generate reports on their content. Power is now transitioned in to the hands of […]

Read More

Disable feedback surveys in Power Platform

If you have worked in Microsoft 365 PowerApps or Power Automate, you might be familiar with feedback survey which pops up quite often. Microsoft wants your feedback on how likely are your to recommend Power Automate to a friend or colleague? Well, I ran into a conversation in twitter about this survey. Apparently I learnt […]

Read More

Missing a column in SharePoint list/library filter pane

Missing a column in SharePoint list/library filter pane? It is normal. Not all columns are available in the filter pane by default. What is filter pane? Filter pane is available in the top right hand corner in list or library page. It is available by clicking on the funnel icon. Filters available are based on […]

Read More