We have a Power BI PPU trail account. We have built a report and published it to the PPU dedicated workspace; also created a flow in Power Automate to automate the export of the report in a PDF format. While doing so we are facing the following error:
Can you please guide us further on this.
Thanks in advance,
I get the same eror as you and I tnink it is simply because the PowerBi features are not available with a PPU Licence, but only with a Per Capacity Premium Licence (the full and expensive one .. :-))
From my point of view, and because of this lack, the PPU licence is in fact not interesting, unless you want to use paginated reports.
@Syndicate_Admin I have the same exact issue, and if the PPU is not doing such a simple task, that won't force me by anyway to even try PPC, I am in the PPU trial, but surely will not upgrade 😞
I think it is not, by design.
Please check this MS documentation with the list of limitations, including:
The answer is clearly No.
You cannot export a PowerBi report, with PPU Licence using Power Automate.
The only reports you can export with Power Automate are Paginated Reports.
There s no workaround 😞 at a time..
Nevertheless here is how I proceed :
Evertime I have a report to develop for and end user, I ask him some question in order to determine if the report will be a "PowerBi Report" (no automatic export,) or a "Paginated Report" (automatic export possible).
This way it works quiet well, even I have to admin that sometimes, some reports are redondant between the two platforms. But, and because I only work with SQL queries to get the data it is quiet fast to get them in both reports format. :-))
I m not saying that it is the best way to proceed, but it is mine .. :-))
Last week I followed the same steps and my flow worked.
But today, the same flow is not working.
Seems like there is some issue with Power Automate service.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.
The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.