Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hello,
I am trying to connect Power BI to our ticketing system API to get ticketing data for a Power BI report. I am using Power Query Advanced Editor to write the code to connect to the API POST.
Here is my code to connect to the API:
I have used the API Reference guide to build this code just like their examples and I keep getting either two errors.
First error:
When I set Cookie equal to sessionKey={created api key}
Second error:
I thought the API didn't like the text "sessionKey" in the header so I took it out and changed it to this:
and get this error
I have tried multiple modifications and cannot get it to work. I am using Anonymous access currently. I tried using Web API access and get this error when I enter in the API Key.
Any help would be appreciated.
Thanks,
Tim