Skip to main content
cancel
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.

Reply
vhroncova
Frequent Visitor

OData Credentials not working while setting up scheduled refresh

Hello, 

data refresh with the same credentials is working properly on my local computer, however after deploying the report to powerBI it's not possible to schedule refresh due to an issue with OData credentials (see attached image)

Failed to update data source credentials: OData: The annotation 'odata.id' was found. This annotation is either not recognized or not expected at the current position

Activity ID:52a8c630-4539-4beb-a871-ec798c768d07
Request ID:87868f4a-e02e-9914-e851-30f0df21fc77
Status code:400
Time:Wed Apr 08 2020 15:15:54 GMT+0200 (Central European Summer Time)
Service version:13.0.12739.219
Client version:2003.3.022
Cluster URI:wabi-europe-north-b-redirect.analysis.windows.net/
4 REPLIES 4
Greg_Deckler
Super User
Super User

I don't see an image, do you have a data gateway installed that you are using? Is odata.id a parameter?

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

We don’t use  gateway for odata, we use direct odata credential connection.

 

i was not able to uploadan image so the error message si copied in the post.

What is the source for the OData connection? Sounds like the OData feed or data coming back is not correct. Let me look at this again.

 

And sorry, for some reason I was thinking ODBC. Too many acronyms, not enough coffee.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hi, 

no problem 🙂 

our data source is this:

 
strange thing is that it's working with the same credentials locally without a problem.

Helpful resources

Announcements
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

PBI_APRIL_CAROUSEL1

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