Forum Discussion
How to specify HTTP request header parameter in Power BI service
Hi Sergiy,
I see you're trying to get data from the Power BI API by writing your own M code in the Power Query Editor - this is not going to work unfortunately, because it is not possible to work with APIs that use OAuth2 authentication in this way. The only way to get data from an API that uses OAuth2 authentication is by creating a custom connector; there is a reasonably easy way to do this that I describe here https://blog.crossjoin.co.uk/2018/11/13/openapi-power-bi-rest-api-m/ and I think other people have blogged about this too.
HTH,
Chris
to be correct - I specify HTTP request header parameter in my M code but that is not enough apparently.
Something is missed.
I think this article explains what is happening:
The auther says:
For cloud data sources connecting to a URL, a test connection is performed against the root URL. This may be a blocker where the URL contains authentication keys, for example. Enabling Skip test connection also helps in such scenarios.
OK, but there is no such option "Skip test connection" visible.
The article starts saying:
we have temporarily disabled the “skip test connection” feature
Is it really disabled now and I have to wait, or there never were such an option in a window whose screen I provided?