Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

ASYNC - API - XML

Hi Community,

 

I'm trying to import data into Power BI from an application where I have a custom report that I want to extract.

The API I use is a ASYNC type call

Now the way it works in the URL web browser is that

1) I put in the URL and press enter - that runs the job and returns a JOB ID

2) Wait a couple of minutes

3) I grab the JOB ID and place it into another URL which gives me the XML

 

To load into Power BI, I copy the XML from HTML into Notepad and then rename the txt file to .XML and import into Power BI.

Is there a way I can Automate this?

3 Replies