Trouble connecting to Meraki API with Power BI

[KJohnson]

I've been trying to connect to the Meraki API using Power BI and haven't been able to get it to work. Everything works OK in Postman so at least the API key is correct.

here's what I've tried in Power BI

    Get data / From Web / Advanced

    filled in the URL and headers, the Authorization header has the API key

When I click OK I get the following error:

If I remove Authorization from the header I get different options to connect

Basic authentication.

I put the API key in the user name and the error is: "We couldn't authenticate with the credentials provided, please try again"

I also tried with the API key in both the user name and password fields, same error.

Web API authentication - API key is in the key field

On this attempt the error is: "A web API key can only be specified when a web API key name is provided"
I've googled the various errors, but still haven't been successful in getting a web API connection using Power BI.

[Oren · Accepted solution]

Do you have “Bearer” before the API key?

https://community.meraki.com/t5/Developers-APIs/Difficulty-connecting-to-Meraki-Dashboard-API-from-P...

[KJohnson]

Thanks Oren, that was the problem. I had to set the authentication to Anonymous and add "Bearer" in front of the API key.

[Oren]

I’m glad to hear. Good luck!