Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
New to PBI and i am gievn a link (API) to a cloud based application, trying to connect using web but it will not connect. The API is link to a applicaiton on the cloud which has credentials , which inturn connects to the SQL DB.
What is the best way to import data.. the link i am given is https://unity.allscriptscloud.com , is this an API?
Thanks
Sujay
Hi @Z1594764 ,
https://community.powerbi.com/t5/Power-Query/Pull-data-from-a-REST-API-Authentication/td-p/246006
https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/
Hope these help.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
Best Regards,
Eyelyn Qin
Hi @Z1594764
You can use a Web.Contents query to get data from an API. There are lots of different types of API's and connections and you'd need to read up on the API documentation to see exactly how you connect to it and how you get data from it.
I tried accessing that link but got a 403 Forbidden error so it might need some sort of authentication to access.
Further reading Getting Started with API's in Power Query
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |