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
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
235 | |
49 | |
47 | |
44 | |
42 |
User | Count |
---|---|
297 | |
211 | |
82 | |
75 | |
65 |