cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Angel
Resolver III
Resolver III

Get ODATA - We couldn't authenticate with the credentials provided - Basic authentication

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,

 

1 ACCEPTED SOLUTION

Hi, @v-jiascu-msft

 

I have found a solution, replacing %26 by character & in URL ODATA.

 

Thanks, anyway

View solution in original post

5 REPLIES 5
v-jiascu-msft
Microsoft
Microsoft

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

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

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.

Get_ODATA_We_couldn_t_authenticate_with_the_credentials_provided_Basic_authentication

 

Best Regards,

Dale

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

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.