Forum Discussion
How to specify HTTP request header parameter in Power BI service
- 7 years ago
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
Hi Anonymous ,
Thank you for trying to help.
1.
Regarding using a parameter. I use it. It might have been not so obvious from my screens, but I use it.
Parameter is 'Groups_Bearer'. I made it noticeable on the screen below.
2.
Regarding your suggestion adding RelativePath optional parameter to web connector.
Unfortunately It didn't work:
With regard to the statement I mentioned earlier "For cloud data sources connecting to a URL, a test connection is performed against the root URL." I assume that your advice should have worked if the root URL could have been hit without supplying an authorization Bearer. Apparently even with RelativePath option specified the root URL still couldn't be hit.
I'd like to quote once more:
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.
I might be wrong but I suspect that if I skipped a test connection where the authorization Bearer I provide isn't applied than the actual dataset refresh where the authorization Bearer is applied would succeed.
Dear Anonymous , could you clarify the statement made at the beginning of the article:
Update: Due to few issues identified recently, we have temporarily disabled the “skip test connection” feature . We are working on making this available again for on-premises data sources by late-June. For cloud data sources we don’t have an ETA yet, but will circle back as soon as we do.
- Does this mean that the option "skip test connection" will become available for the web connection I am willing to make?
- Was the option "skip test connection" available at the time of announcement was made for the web connection I am willing to make?
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
- Sergiy7 years agoResolver II
Hi Chris,
Thank you very much for the references you provided. I'll definitely try to use them to my advantage!