Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, everyone
I hope someone can help me..
We have installed Power BI Desktop in a Windows 2012 R2 Standard Server.
When we try to get ODATA feed in Power BI desktop, it appears message 'We could´nt authenticate with the credentials provided'. However, it works ok if we input same URL and same credentials in web browser.
Any idea???
Thanks,
Solved! Go to Solution.
Hi, @v-jiascu-msft
I have found a solution, replacing %26 by character & in URL ODATA.
Thanks, anyway
Hi @Angel,
What's the source exactly? The local OData sources, or others?
Do you have the latest version of Power BI?
Best Regards,
Dale
Hi, @v-jiascu-msft
Source is ODATA from Dynamics NAV 2017.
The issue happens with last version of Power BI Desktop. However, It works ok if i check 'ignore privacy levels'.
'Ignore privacy levels' is not supported in Power BI Service. So, when I publish the pbix file and try to connect to ODATA using a gateaway, it appears 'credentials invalid' again. I have installed on-premise gateaway and it's online.
That's the message.
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details Activity ID: 06c40c83-53ab-4dfa-9036-de310ce537f6 Request ID: fb2530fb-d8a0-79d2-9887-e55633a1a874 Cluster URI: https://wabi-west-europe-b-primary-redirect.analysis.windows.net Status code: 400 Error Code: DMTS_PublishDatasourceToClusterErrorCode Time: Thu Aug 23 2018 22:05:56 GMT+0100 (hora de verano de Europa occidental) Version: 13.0.6358.131 Noray Power BI - Puerta enlace: Invalid connection credentials. Underlying error code: -2147467259 Underlying error message: Se requieren credenciales para conectarse al origen OData. (Origen en http://servernav.server.local:9048/DynamicsNAV100/OData/Company('TEST%20HOTEL%20RESORT%20&%20SPA')/ConfiguracionNorayBI.) DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.CredentialError.DataSourceKind: OData Microsoft.Data.Mashup.CredentialError.DataSourcePath: http://servernav.server.local:9048/DynamicsNAV100/OData/Company('TEST%20HOTEL%20RESORT%20&%20SPA')/ConfiguracionNorayBI Microsoft.Data.Mashup.CredentialError.Reason: CredentialMissing Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"OData","path":"http://servernav.server.local:9048/DynamicsNAV100/OData/Company(\u0027TEST%20HOTEL%20RESORT%20\u0026%20SPA\u0027)/ConfiguracionNorayBI"}] Microsoft.Data.Mashup.MashupSecurityException.Reason: CredentialMissing Troubleshoot connection problems
Hi @Angel,
I would suggest you upgrade the Data Gateway to the latest version first. You can change the privacy level in the Advanced settings like below.
Do you have a credential other than the basic authentication? Seems it isn't accepted.
Best Regards,
Dale
Hi, @v-jiascu-msft
I have found the problem... URL ODATA has the character & and it seems Power BI Service doesn't support it.
Maybe, I must report and issue for this.
Thanks anyway
Hi, @v-jiascu-msft
I have found a solution, replacing %26 by character & in URL ODATA.
Thanks, anyway
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |