Using POST Request in Power BI

ferdsjoseph · November 19, 2018, 11:17pm

Hi Fellow Power BI Users -

Using the app called POSTMAN and the code below, I am able to get a data dump in XML format from this URL (https://api.adaptiveinsights.com/api/v14). Is it possible to use these pieces of info to get the data straight into Power BI?

Best regards,

Ferdinand

sam.mckay · November 20, 2018, 12:33am

Interesting. I don’t know this one actually.

Have done a bit of research it looks like you can.

Have you seen the below?

ferdsjoseph · November 21, 2018, 12:43am

Thanks for the resource. After a lot of googling, I was able to make it work. The key was using the Text.ToBinary() function and using double " (double quotes). The rest is just parsing the xml output to transform it into a normalized table.

Best regards,

Ferdinand