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

Join 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.

Reply
zaxlearnsdax
New Member

RealMagnet/HigherLogic Data Source - Rest or SOAP API as Data Source

Howdy Daxers!
Not new to PowerBI - but definitely new to APIs as data sources (yah yah yah)

I'm looking to get data from the following platform/API type into PowerBI.
Honestly, I've searched all over - from Zappys/ODBC, Postman, Cloud Storage and API managment,

Honestly - just wondering the 'best place to start' to get daily data calls via the API below into a local server or folder on my local network so it can be pulled in by PowerBI.

Here's the platform/API:
https://support.higherlogic.com/Content/IWantTo/LearnIntegration/MA/Enterprise/API/RESTAPI.htm?TocPa...

I know there are other threads about this, but wondering:
1) Anyody here has experience with this specific platform
2) The best/most efficient and easy way to get this done




1 ACCEPTED SOLUTION
TeigeGao
Solution Sage
Solution Sage

Hi @zaxlearnsdax ,

Generally, we can use the Web.Contents function in Power Query to send the post and request to the REST API, please refer to this problem to get more information: https://community.powerbi.com/t5/Power-Query/M-Query-to-use-POST-method-on-a-Web-API/td-p/112895, but sometimes, this function cannot work for some API, then we will need to use Python script to get data from API, then convert the result to DataFrame object, PowerBI can read these data.

 

Best Regards,

Teige

View solution in original post

1 REPLY 1
TeigeGao
Solution Sage
Solution Sage

Hi @zaxlearnsdax ,

Generally, we can use the Web.Contents function in Power Query to send the post and request to the REST API, please refer to this problem to get more information: https://community.powerbi.com/t5/Power-Query/M-Query-to-use-POST-method-on-a-Web-API/td-p/112895, but sometimes, this function cannot work for some API, then we will need to use Python script to get data from API, then convert the result to DataFrame object, PowerBI can read these data.

 

Best Regards,

Teige

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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