OData error 404 Not Found 414 URI Too Long using API Key

Hi  Den123 ,

In the methods you’ve found, I recommend using the third and fourth ones.

For the ‘api_key,’ use headers for secure transmission.

Web.Contents - PowerQuery M | Microsoft Learn

“If your ‘api_key’ parameter is a constant value, you can also use a token to include it. Every time you need to retrieve the ‘api_key’, this dynamically generated token will be automatically triggered, providing enhanced security. Alternatively, you can consider using environment variables or secure vault services (if available) to store and reference the ‘api_key’.”

Refer to:

Call Power BI Rest API with Dynamic Access Token From Power BI Desktop |Power BI Rest API | Part Two (youtube.com)

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.