Using POST Request in Power BI


#1

Hi Sam,

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?

image

Best regards,

Ferdinand


#2

Interesting. I don’t know this one actually.

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

Have you seen the below?


#3

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