Export and send a paginated report by e-mail

[mfofana24]

Hello,

I would like to send a paginated report to my customers by e-mail, on request. After creating the paginated report, I integrate it into Power BI Service. I then apply the necessary filters to select the desired data. An integrated button in Power BI triggers a Power Automate flow that exports the report as a PDF and sends it to customers.

However, I'm encountering a technical problem with the configuration of multi-value filters. Could you tell me how to configure them correctly?

Thank you in advance for your help.

[v-csrikanth]

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!

[v-csrikanth]

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.

[v-csrikanth · Accepted solution]

Hi @mfofana24 

Could you please verify below points.

• Ensure your DAX query is correctly written and does not contain any syntax errors.
• Try running the query directly in DAX Studio or the Power BI Desktop Model to confirm it's valid.
• Large datasets or complex queries may exceed the dataset size or timeout limits.
• Ensure that the version of Power BI Report Builder is up to date, as older versions may have compatibility issues.(https://www.microsoft.com/en-us/download/details.aspx?id=58317)
• If the Power BI dataset has been modified (columns or measures removed), the report may fail to execute the query.

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

Thanks,
Cheri Srikanth

[v-csrikanth]

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.

[mfofana24]

Hi @v-csrikanth , 

My paginated report in Power BI Report Builder fails with the error ‘DAX query fails to prepare,’ despite having a valid data source connection and configured parameters. How can I resolve this issue ?

[v-csrikanth]

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

[v-csrikanth]

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

[mfofana24]

Thank you, after PA Flow setup i have this error message : 

Error from token exchange: Permission denied due to missing connection ACL: Connection https://europe-002.azure-apim.net/@europe-002/logicflows/02963388-0ff6-428f-a190-17f52a64966e version -9223372036854775808, connection=europe-002/powerbi/shared-powerbi-a48bc5ec-d624-417a-990b-ec2c377bc681

[mfofana24]

@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) ?

[v-csrikanth]

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