Panorama and Power BI

[MariusD]

Hi,  

I'm trying to get the summary report from Panorama using an API. I have generated my API key and I can get the xml output in Postman but I'm struggling to get the same API call to work from Power API. I keep getting the same error: Details: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."

I'm using the web data source option in PBI and have tried all combinations I think off but nothing seems to work:

1. use the API key option when setting up the data source

2. use the X-PAN-KEY valued in the header of the API call 

3. use the key parameter in the body of the API call 

4. use username and pass combination when setting up the data source connection. 

If anyone has successfully ran an API call from PBI please let me know what is the correct setup. 

Thank you!