topic Re: GET Data via Web API: Error No Query in Developer

GET Data via Web API: Error No Query

VJR1998 — Thu, 05 Aug 2021 10:16:37 GMT

I'm trying to add a new table to Power BI from a database that is linked via an API. I've checked the link provided and the API key and its all correct. I've also entered the link into my browser and using Postman, both of which successfully return the JSON.

However, once in Power BI I receive the error below:

Struggling to figure this out or where to look so any help would be appreciated.

Re: GET Data via Web API: Error No Query

lbendlin — Thu, 05 Aug 2021 22:02:51 GMT

Please give us something to work with. A sanitized version of the advanced editor code, for example.

Re: GET Data via Web API: Error No Query

Anonymous — Tue, 10 Aug 2021 01:01:53 GMT

Hi @VJR1998,

Can you please share some more detailed information about your operations? It should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Re: GET Data via Web API: Error No Query

VJR1998 — Tue, 10 Aug 2021 09:51:30 GMT

No need to worry, ive resolved it now! Seemed to be an issue with Power BI and a fresh install seemed to do the trick!

Re: GET Data via Web API: Error No Query

Anonymous — Thu, 12 Aug 2021 05:40:59 GMT

Hi @VJR1998,

I'm glad to hear this issue has been resolved. 😊

According to your description, it seems like a compatibility issue between different versions.
If you can please share the old version numerb of power bi desktop which faced the issues and it should help with others who faced the similar scenarios.

Regards,

Xiaoxin Sheng