Using Power Automate in Power BI Service to Append Dates on File

[mjsystemss]

Hi,

I need Ideas on why I had this error.

I have a paginated report in Power BI Service and with a pro license I want to append date on file name using power automate. I get the error below when I tested the flow. Could the pro license be a problem?

[mjsystemss]

So the Pro license cannot work?

[tayloramy]

Hi @mjsystemss, 

That is correct, a pro license is not enough to do this, you need to have a premium or fabric capacity.  

This is outlined here: 
Export and email a report with Power Automate - Power BI | Microsoft Learn

Prerequisites

To follow along, make sure you have the following prerequisites:

• 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.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[mjsystemss · Accepted solution]

Hello, I am able to set it up with a Pro License. I think it works. I have attached both the flow and test results

[mjsystemss]

The Steps:

1. Go to Make.powerautomate.com

2. In the left click Create
3. Choose Automated Cloud Flow
4. Give it a name- and save
In the flow box search for When a new email arrives (V3) , select folder and fill in
Include attachments             Yes

Only with Attachments         Yes

From                                      email address

Subject filter                          Report Name
Click on Save

Next Add The Loop

5. Click  + New Step
6. Search apply to each under control

7. In the field select an output from previous steps click inside and click on dynamic content and select Attachments
8. Under 6 click on + add an action

9. Click on Microsoft 365 outlook and select Get attachment (v2)

10. click on tab dynamic content and search for message Id. Also click on attachment Id field and dynamic content and select attachment id

11. add compose filename step. Click on add an action and search for compose, select it and click on expression and type in concat('report name_', formatDateTime(utcNow(), 'yyyy-MM-dd'), '.xlsx') and click ok. Rename compose to compose filename by clicking on the ... and select rename

12. Click on + add an action

13 search for condition and select condition under control. click inside the box on the left and click expression and paste endsWith(toLower(item()?['Name']), '.xlsx') click ok

14. middle box remains is equal to

15. right box click on expression and typr true and click ok.

16. 2 boxes appear under Yes and no. No side remains the same. In the yes box click + add an action. search for send an email (V2) under Microsoft 365 outlook}

17 fill he card
To: email addresses of users
Subject Report name - @{formatDateTime(utcNow(), 'mmmm dd, yyyy')}
Email body
Advanced Options:

From (Send as): Email account you want the email to go out from. Exchange admin can help if not available
Attachments:

Name: Click inside > Expression and type outputs('compose_Filename') click Ok
ContentByte > click inside> click expression> type body > select Get attachment (v2) from suggested list and complete the expression> body('Get_Attachment_(V2)')?{'contentBytes'] Click OK. 
You are set

[tayloramy]

Hi @mjsystemss, 

Are you trying to generate a PDF/extract of the pagianted report with a date on the end? 

Can you share the error message from the flow, and show us the details of your export file step? 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[mjsystemss]

Hi,

Below is the error detail. I am using a pro license but not sure if that is the issue.

[tayloramy]

Hi @mjsystemss, 

THat is very helpful, thanks for sharing. 

To be able to export a report like this, the report needs to be attached to a Fabric capacity, it can't be sitting in a pro workspace or "My workspace". 

Move the workspace that the report is in to a Fabric capacity and then it should work. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.