Forum Discussion
Anonymous
5 years agoNot applicable
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
- amitchandakSuper User
Anonymous , You can check if you can use Power Automate in this case.
- AnonymousNot applicable
Hi amitchandak
How would I do that and do I need a pro licence to use it.
- AnonymousNot applicable