Extract the report to PDF and sent it via mail

[andreazambon]

Hello there. 

I built a flow to extract my report in PDF and send it via mail to some users.

The flow fails in the extract component because, it siy, it can't find the report:

{
  "error": {
    "code": "FeatureNotAvailableError",
    "pbi.error": {
      "code": "FeatureNotAvailableError",
      "parameters": {},
      "details": []
    }
  }
}

I tried with different reports without success, here's my setup.

Can someone help me with this?

Thankyou

[v-kongfanf-msft]

Hi @andreazambon ,

Yes, as you said. the Power BI report is exported as a PDF and attached to a weekly email that is sent out.
Some prerequisites are required:

• At least one workspace in your Power BI tenant backed by a reserved capacity. This capacity can be any of the
• A1/EM1 - A6/P3 SKUs. Read more about reserved capacities in Power BI Premium.
  Access to the standard connectors in Power Automate which come with any Office 365 subscription.

For more details, you can refer to below document:

Export and email a report with Power Automate - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[andreazambon · Accepted solution]

I got it:

you need a capacity premium license. Premium-per-users does allow you to export PDF from the service but not from the APi via PowerAutomate. 

Hilarious.