Forum Discussion
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?TocPath=I%20WANT%20TO...%7CLearn%20About%20My%20Integration%7CMarketing%20Automation%7CEnterprise%7CREST%20API%7C_____0
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
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
1 Reply
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