Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper I
Helper I

My report is not able to perform refresh on power bi service. It works fine in Power BI desktop.

Here is the error message I am getting. can someone help me on this? FYI: My datasource was previously connected to SQLSERVER  and later I changed it via OLEDB connector and since then whenever I try to perform refresh, I receive the below error.

I tried to change credentials but it didn't work.

 Data source error: {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the OleDb source are invalid. (Source at application intent=READONLY;data source='datasource';initial catalog=OCS_Crane;provider=SQLNCLI11.1.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"OleDb"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"provider=SQLNCLI11.1;initial catalog=name;data source=datasource;application intent=READONLY"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"OleDb\",\"path\":\"provider=SQLNCLI11.1;initial catalog=databasename;data source=datasource;application intent=READONLY\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: xyz.
Cluster URI:
Activity ID: 4128a1b5-6bad-4a88-b529-9ceb1d998751
Request ID: fbc2d704-2923-8b43-cf68-f7b0c7087ff8
Time: 2021-06-11 19:51:46Z

Frequent Visitor

Hi Pooja_Panya,


Did you resolve this issue? 

I have tried everything and am yet to fix it.


Kind Regards,


Community Support
Community Support

Hi @Pooja_Pandya 

Has your problem been solved ?If it has been solved, provide your method for the problem then consider Accept it as the solution to help the other members find it more quickly.


Best Regards

Community Support Team _ Ailsa Tao

Hi @v-yetao1-msft 


Thanks for reaching out.

Yes, refresh works fine in power bi desktop version but when I published the report to service by adding a data source and made a connection with gateway by upgrading the credentials it returns me the above error. I verified the credentials and data sources with my DBA. Data source is connected up and running but the issue is with the refresh only so not sure what to do.

Community Support
Community Support

Hi @Pooja_Pandya 

So you mean, after you migrating the data source to OLE DB, there is no problem when you refresh in the power bi desktop, but when you refresh in the service, you get an error, right ?

If this is the case, have you considered the issue of gateway ? You may need to update the credentials in the gateway settings of the service. Because from the error info you provided , it has mentioned that the credentials provided are wrong .


Best Regards

Community Support Team _ Ailsa Tao


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Champion
Community Champion

Hi @Pooja_Pandya 

How did you change the source in desktop?

Did you Change credential or install a new gateway on premises?


Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors