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.
... View more