Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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: WABI-NORTH-EUROPE-C-PRIMARY-redirect.analysis.windows.net
Activity ID: 4128a1b5-6bad-4a88-b529-9ceb1d998751
Request ID: fbc2d704-2923-8b43-cf68-f7b0c7087ff8
Time: 2021-06-11 19:51:46Z
Hi Pooja_Panya,
Did you resolve this issue?
I have tried everything and am yet to fix it.
Kind Regards,
Sam
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
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.
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.
How did you change the source in desktop?
Did you Change credential or install a new gateway on premises?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
39 | |
33 | |
31 | |
25 |