Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Z1594764
New Member

API from Cloud application

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

2 REPLIES 2
v-eqin-msft
Community Support
Community Support

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

PhilipTreacy
Super User
Super User

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.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.