Forum Discussion
RealMagnet/HigherLogic Data Source - Rest or SOAP API as Data Source
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
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