Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
hi all
I'm having difficulties setting up powerquery to get info from an API.
I use Postman and everything is working just fine.
So from above I'm using the URL from the GET and add it in the URL below and I use the token and add it to the Headers as per below.
I use Anonymous auth.
This gives me the following error
I dont get it. Could you help ?
I specify that in order to receive the token I do use another GET action (GetToken). but having this token this should work fine...
thank you !
Solved! Go to Solution.
Hi @Anonymous
It seems you are using the incorrect header paramter for token. Use Authorization rather than X-API-KEY and add "Bearer " before the token. You could refer to this link: powerbi - Where do I save token in Power BI web connection?
Other reference:
powerbi - How do I retrieve a bearer token from a service in Power BI?
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Hi @Anonymous
It seems you are using the incorrect header paramter for token. Use Authorization rather than X-API-KEY and add "Bearer " before the token. You could refer to this link: powerbi - Where do I save token in Power BI web connection?
Other reference:
powerbi - How do I retrieve a bearer token from a service in Power BI?
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |