Forum Discussion
Help: Custom Visual - Download API working in powerbi services but not working in the embedded link
Hi WhyComplex ,
I think firstly if you can capture the URL of the download report request, you could create a button via script that initiates the download. You can read this topic: Solved: Need to download the Embedded Power BI report from... - Microsoft Fabric Community
Another alternative is to upload the report file to cloud storage and save the download link in the report as a URL. Then, create a button in your Power BI report that links to this download address.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yilong-msft ,
I saw that suggestion.
However, I am pulling data from SQL and there is no existing excel file, I want to avoid having files sitting in sharepoint or onedrive.
This is the reason why I am using the download API. It allows me to get my my data through the variable options.dataViews[0] (Custom visual capability) and send it straight into the API for download.
In addition, the API allows me to take advantage of filters and push only the selected data whereas in your solution it is the whole backend that is being downloaded.
So is microsoft planning to open the API in the embedded link of the report (URL structure https://app.powerbi.com/reportEmbed?reportId=XXXXXXXXX) ?
Best regards,
Marc