Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
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
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.