Forum Discussion
Authentication Method "Web API" not supported in Power BI Service
Hi BjoernLueers
It sounds like you need to specify an API key name in the headers area of Web.Contents using the advanced editor. See Chris Webb's post on this for a good example: https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/.
Here's another post probably helpful for you:
If the issue still exist , please kindly raise it to support team: https://powerbi.microsoft.com/en-us/support/
Both of those approaches appear to involve hard-coding secrets into the PBIX file, which is not good from a security perspective. Anyone who gets the PBIX gets my secret.
I would expect that the PBI Service would manage the API Keys with the same approach as with Basic Auth, where the secret is write-only (only the service can get at it).
Jason
hey did you got any idea how to not hardcode credentials and use powerbi auth only for POST API call??
