Forum Discussion
Data from URL with auth key
Hi,
Can anyone tell me the way to import data from an url which has auth key.
6 Replies
Hey AishwariyaV,
I would open a blank query and do that what this guys have done ->
- https://community.powerbi.com/t5/Desktop/Power-query-to-connect-REST-API-with-basic-authentication-is/td-p/358186
- https://community.powerbi.com/t5/Desktop/Using-a-REST-API-as-a-data-source-POST-Method-Only/td-p/244166
If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others
Have a nice day!
BR,
Josef
Graz - AustriaHi @JosefPrakljacic ,
I have tried using M query it directs me to that error. And I have been told that I shouldn't give "Anonymous" in that access web content dialog box.
Hey AishwariyaV ,
could you please verify that works in principle with free Software called postman?
Since I'm not able to test with your backend its a bit hard to help you here out.
BR,
Josef
Hi AishwariyaV ,
Based on this similar thread, there is a workaround for the Get Method:
API Method:
- GET
Steps:
- Click Get Data
- Click Web
- Click Advanced
- Enter entire query string with parameters
- Enter API Key and Value as a header
- Click Connect
- HERES THE SECRET: Select "Anonymous"
- It was intuitive for me to want to click "API Key". But this is what resulted in the error.
BTW, We suggest you to black the API Address in your picture.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
