Export and send a paginated report by e-mail

Hi mfofana24 
Welcome to the Microsoft Fabric Community Forum.
Please ensure the below steps to resolve your issue:

Configure Multi-Value Parameter in Power BI Paginated Report:

Ensure that your paginated report in Power BI Report Builder is set up to handle multi-value parameters correctly:

• When creating the parameter, enable "Allow multiple values" in the report parameters settings.
• If the parameter comes from a dataset, ensure it provides a list of values.

PA Flow setup:
In your Power Automate flow, when calling use the "Export To File for Paginated Reports" connector in PA.

Multi-value parameters should be passed as a comma-separated string with URL encoding.

PA might require it in a JSON array format like:
**************************************
["Value1", "Value2", "Value3"]

**************************************
If your values are dynamic (coming from a Power BI button trigger), you can use automate expressions to format:

**************************************

join(triggerBody()?['Region'], ',')

**************************************

If the above information helps you, please give us a Kudos and marked the reply Accept as Solution.

Thanks,
Cheri Srikanth

v-csrikanth Thank you for your feedback, precision this is possible with a power bi per user license and a Microsoft E3 license (not prenium) ?

Hi mfofana24 
Yes, exporting and sending a paginated report via PA using Power BI Service is possible with a Power BI Pro (Per User) license and a Microsoft 365 E3 license, but with some limitations.

Licensing Requirements:

1. Power BI License:

   • Power BI Pro is required for exporting paginated reports via Power Automate.
   •  PPU or a Premium Capacity license is required if the report is hosted in a workspace that requires premium features.
   • Without a Premium license, paginated reports can only be used within My Workspace or shared via Pro-licensed workspaces.

2. Microsoft 365 E3 License:

   • This license provides access to Power Automate, but does not include Power BI Premium features.
   • If your Power BI reports are hosted in a non-premium workspace (Pro-only), the paginated report export will work under Pro license constraints, such as:
     • 50MB file size limit per report.
     • Limited concurrent export requests.
     • Execution time limits.

Additionally, you can also find the few lmits and configs:

https://learn.microsoft.com/en-us/power-automate/limits-and-config#timeout 

If the above information helps you, please give us a Kudos and marked the reply Accept as a Solution.

Thanks,
Cheri Srikanth

Hi mfofana24 

Here are a few things that you can check to help resolve the issue:

Verify Power BI Service Permissions:

• Ensure that the account being used in the Power BI service has the required permissions to access the dataset and report.
• Navigate to BI Service > Workspace > Settings > Access, and confirm that the user account has at least a Viewer or Contributor roles.

Reconnect the Power BI Connector in Power Automate:

• In PA, go to Data > Connections.
• Locate and remove the existing Power BI connection.
• Re-establish the connection using an account with the appropriate permissions.
  
  

If the above information helps you, please give us a Kudos and marked the reply Accept as a Solution.

Thanks,
Cheri Srikanth

Hi mfofana24 
We haven't heard from you since last response and just wanted to check whether the work around provided has worked for you. If yes, please accept as solution to help others benefit. If not, feel free to reach out.
Thank you.

Hi mfofana24 

I wanted to check if you had a chance to try the suggested solution.
Please let us know if you need any further assistance.

Looking forward to your update!

Thank you.

Hi mfofana24 
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!