Failed to find a match for the data source

Failed to find a match for the data source

  • Comments 1
  • Likes

I’ve seen this following scenario come across a few times.  When trying to run a Scheduled Data Refresh, you may see an error similar to the following:

“Refreshing the data failed”

image

Within the Power BI Admin Center, if you go to System Health, you will see an error listed there.

image

Hovering over the message, we see something similar to:

Failed to find a match for the data source (connection string: provider=SQLOLEDB.1;integrated security=SSPI;persist security info=True;data source=section31;use procedure for prepare=1;auto translate=True;packet size=4096;workstation id=SECTION31;use encryption for data=False;tag with column collation when possible=False;initial catalog=ReportServer) for the user 'asaxton@saxton201406.onmicrosoft.com'. The user is unauthorized or, the corresponding data source is not created. Check the user's permission to the data source or create a data source for the connection string. Error code: 4004

When we go to the Data Sources in the Admin Center, we see one Data Source listed.

image

This data source is configured to use the .NET Provider for SQL Server.

image

When we do the Scheduled Data Refresh operation, we use the connection string within the workbook, to match against a configured Data Source.  In the example above, the workbook was using the SQL Server OLEDB Provider that ships with Windows.  Our data source was configured for the .NET Provider, so we couldn’t find a match and therefore failed.

To resolve this, we can another Data Source that uses the SQLOLEDB Provider.

image

Once that data source is configured, the refresh will start working at that point, as it finds a successful match.

Adam W. Saxton | Microsoft SQL Server Escalation Services
http://twitter.com/awsaxton

Comments
  • My problem is I get the same error but in my case I'm using oData, the error detail is below, the thing is that the url is copied from the actual data source so they match, also the gateway is logging a successful reply to the request for the refresh but the server still not happy, any ideas?

    Failed to find a match for the data source (connection string: https://bts70.hybridproxy.powerbi.com/ODataService/v1.0/ResearchOlap) for the user 'fvalencia@BTS70.onmicrosoft.com'. The user is unauthorized or, the corresponding data source is not created. Check the user's permission to the data source or create a data source for the connection string. Error code: 4004


    Tracing ID: 6e186e25-8773-4489-92ff-21b81a275b06

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment