Forum Discussion

jwillis07's avatar
jwillis07
Advocate I
5 years ago

How to Authenticate a REST API in Power BI?

Good evening all, I'm in need of some help and I hope I've come to the right place...   I've only ever worked with local files or open APIs however this time, I'm trying to access a REST API but I'...
Need Help
Tutorial Requests
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi jwillis07 ,

 

If you want to Authenticate a REST API in Power BI. You should first need to clear the permission in the data source setting, the choose "Web API" instead of "Anonymous", then make a try.

 

 

Provide corresponding official documents for reference: Power Query Web connector | Microsoft Docs


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BizviG's avatar
BizviG
New Member
3 years ago

Hi v-henryk-mstf!

I think what we are looking for is a way to pass the authentication in the header INSTEAD of the Web API Key
If indeed that would be the method for activating auth through the header parameters in the case described, what would one write in the KEY-field? Would that be whatever was returned with the Authorization: Basic?