Forum Discussion
Helper IError when i tried to refresh ADOTesPoints OData in Dataflow, works fine in PowerBI Desktop M Query,
Hi sravs2007
Yes, staging OData data into a database and connecting Power BI to the DB is a recommended best practice. It avoids OData service limitation and typically results in more stable refresh and better performance.
Reference : https://learn.microsoft.com/en-us/power-query/connectors/odata-feed
Hope this helps!!
Thank You.
Super UserHi sravs2007,
as of the documentation (Access Analytics data from Power BI Desktop - Azure DevOps | Microsoft Learn) this should work.
Some things you can check:
- do you have proper rights in the ADO org/project?
- check the endpoint schema from the docs. The URL in your code snipped seems to be of what the docs say
- authenticate with your organizational account
- go to a lower version of the endpoint (e.g. V1.0) and check again (this version at least works on my end)
Hope this helps!
Best regards!
PS: If you find this post helpful consider leaving kudos or mark it as solution
Helper Iam having an acess to this project and anlytics is enabled ... when i hit the url in browser i can see response
desk top am getting data, but in dataflow throwing an error