"Report requested for export is not on dedicated capacity" using Power Automate(Power BI)

(5) Share

Report

Posted on by testthirdware

Hi Team,

I get the below error everytime on Power automate flow. Not sure on the issue. Kindy help

Categories:

General topics

I have the same question (0)

All responses (51)

Answers (0)

ScottShearer 25,278 Most Valuable Professional on at

Like (17)

Report
Copy link

Link copied!

@testthirdware

To use this action, you need to have a Power BI Pro license with the Premium add-on to your Power BI license. The new Per User premium add-on does not allow you to use this action - you need the full Premium add-on. Then, the report needs to be in a workspace with the premium capacity turned on.

Was this reply helpful? Yes No
SEMAT 32 on at

Like (11)

Report
Copy link

Link copied!

Hello Scott,
Thanks for this information.
So it means that Power Automate is unusable with Power Bi unless you have the full premium licence at 4000 € / months .... 🙂
Am I right ?
Best Regards,
Jérôme

Was this reply helpful? Yes No
andrew5083 88 on at

Like (26)

Report
Copy link

Link copied!

This is the biggest bull**bleep** I've ever seen Microsoft produce.

Was this reply helpful? Yes No
cattuong 9 on at

Like (1)

Report
Copy link

Link copied!

I've used free trial, but when I tested its still said "Error 403". Can you help me with this? Thank you so much.

Was this reply helpful? Yes No
Darthy 20 on at

Like (9)

Report
Copy link

Link copied!

Dear All,

I'm facing with the same problem. I have to ask why I can't use this option with Pro licence ? And if I can't use this kind of simple option, why do we pay and need Pro Licence?

Does Microsoft think to change this licence problem ?

can anyone say me, is there an any alternative for this ? Because I want to create full automate "Montly Report". But this error is really annoying.

Thanks

Was this reply helpful? Yes No
MicheleMM 5 on at

Like (1)

Report
Copy link

Link copied!

Same issue! Do you find any solution?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (3)

Report
Copy link

Link copied!

Hello Scott,

Do you need the $4995 per capacity/month plan or is the $20 per user/month sufficient to run Power Automate?

I want to send the Power BI pdf reports to users who may not necessarily have Power BI Pro license.

Regards,
Joel

Was this reply helpful? Yes No
MikeJoke 31 on at

Like (13)

Report
Copy link

Link copied!

You have to pay 4k / month to automate the "Export to PDF"?
Which is already available when you press the button on the PowerBI Page.

This feature should be available in any environment, what is the exact reason why you have to pay so much for this?

Was this reply helpful? Yes No
jerome_mazet 25 on at

Like (5)

Report
Copy link

Link copied!

Hello,
Currently, the only way to proceed is to use a combination of "paginated reports" and "Power automate", and that's what I do.

To do it, you'll need a PowerBi PPU Licence (around 8€ / month), in order to publish the paginated reports to the cloud, and a Power Automate licence (nearly the same price).
With these licences, you'll be able to automatically send PDF reports (generated by your paginated reports) to end users via email.

One interesting thing is that a PowerBi report can be seen as a Data Source for a paginated report.
It means that, in your case, you have two possibilities
1- Create your paginated report from scratch (using an SQL query for the Data Set)
2- Use your PowerBi report (already published) as Data Source for your paginated report.

Personnaly I use the first one, but it is up to you :-).
Currently I have around 10 different paginated reports managed with Power Automate and I can say that the service is very stable.

I hope this comment will help you,
Best Regards,
Jérôme.. from France 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (3)

Report
Copy link

Link copied!

Hello All,

Thank you for your suggestions.

I have found a simple solution to this.

In Power BI Pro, you can add users to a subscription list in Power BI online. The users need to have Power BI Pro so that the mails can be sent. For users who do not Pro version, I have subscribed myself to the report and set an auto-forward rule in Outlook to send it to the group of people.

Regards,
Joel

Was this reply helpful? Yes No