Forum Discussion

mjsystemss's avatar
mjsystemss
Resolver I
10 months ago
Solved

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

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?

 

 

121
  • mjsystemss's avatar
    mjsystemss
    10 months ago

    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

     

7 Replies

  • tayloramy's avatar
    tayloramy
    Super User
    10 months ago

    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's avatar
      mjsystemss
      Resolver I
      10 months ago

       

      Hi,

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

       

      • tayloramy's avatar
        tayloramy
        Super User
        10 months ago

        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.

         

    • tayloramy's avatar
      tayloramy
      Super User
      10 months ago

      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's avatar
        mjsystemss
        Resolver I
        10 months ago

        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