Power BI report delivery automation

Question

I have a powerbi report URL which takes me to the report view in web browser and at the same time it downloads the report as .mhtml to my local system.

What I need is to get this .mhtml within alteryx without any need to get it from my local system. I tried using download tool but it seems like it is not working as expected. Any one went through the similar use case ? please help.

My target is to catch this .mhtml  and then convert it to inline-html for that I have created an api end point. Further this converted html will be sent in body of an email. And inside the email body it will look like exactly how it is viewed in browser as a live report.

Gaurav_Dhama_ · Answer

OK to achieve this you will need to use three APIs.

* One that sends a request to start the export
* One that checks the status of the export
* One that gets the files once you get success status from 2nd step.

In your 3rd API, which will be run by Download tool, provide a file path (with extension .mhtml) and export the result as "To File > Filename from a field". See snip below.

Once you have the file, you can take it ahead from there.

ckjha · Answer

Hi abacon,

Thanks for helping me out. What you are suggesting is perfectly fine. But it needs additional app set up on Azure which I am trying to avoid. Can you please suggest me some other way around, so that I won't have to go for additional set up and so?

abacon · Answer

@ckjha How were you trying to download the report? Were you trying to use Power BI APIs to download? I have used the API functionality for a lot of use cases and it's great, it might be what you are looking for here. Admittedly, setting up the API settings within Power BI are tricky but there is a lot of documentation online about it.

I would look into this functionality and see if it's what you are looking for.

https://learn.microsoft.com/en-us/rest/api/power-bi/

Bacon