Access Web content credentials fails while queries work in Power Query

[Anonymous]

Hey, for a report I use web.Contents to create tables from json/csv data from the web. These web.Contents calls are consuming an api that uses a Bearer token for authorization. These queries work within the Power Query editor and actually get the correct data, however not when trying to Apply.

When an Apply step is started, I get an "Access Web content" pop up which tries to verify that the data sources can be accessed, which fails because I can't use a Bearer token header in this popup.

an example of a query that works like this would be something like this:

= Json.Document(Web.Contents("https://<website.com/relevant/path>", [Headers=[Authorization=#"bearer-token"]]))

How can I get past the "Access Web content" popup?

[amitchandak · Accepted solution]

@Anonymous , refer if this older solution can help

https://community.powerbi.com/t5/Desktop/Pull-data-from-RESTful-API-with-token-authentication/td-p/80531