ASYNC - API - XML

[Anonymous]

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?

[Anonymous]

@Anonymous 
For your requirement, you might want to go to Power Automate Forum.

Regards
Paul

[Anonymous]

Hi @amitchandak 

How would I do that and do I need a pro licence to use it.

[amitchandak]

@Anonymous , You can check if you can use Power Automate in this case.