Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Create Power BI report from power automate

I have a power bi template which I want to use with flow.


Whenever a folder is created in sharepoint folder I want to use the power bi template to create a new report/dashboard.


All the data files are stored in the sharpoint folder and all i have to do is pass the folder path to the parameter in power bi template and the dashboard will be created as the data file names won't change,

In the source of all the data files i have use the the parameter as prefix to all data fix path like :
Source = Csv.Document(Web.Contents(folderPath &  "/accountsreports.csv"),[Delimiter=",", Columns=42, Encoding=65001, QuoteStyle=QuoteStyle.None]),where 'folderPath' is the parameter.
Is there a way to do it?
 

dataflow
Need Help

5 Replies

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost Valuable Professional
    2 years ago

    Are you sure you don't want to be using a single report with row-level security to filter instead of creating buckets of reports? If you need to change something in the report later, it will be an unholy terror to fix it in every location if you create a new file each time.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello,

       

      yes, I need to use different report every time because all the reports will be one time use only.

       

      Any changes will be implemented on the reports from that day onwards.

       

       

       

  • pmreis's avatar
    pmreis
    Icon for Most Valuable Professional rankMost Valuable Professional
    2 years ago

    Hi Anonymous 

     

    If the reports are single use, do they need to be in Power BI Service?

     

    I would simplify this with the following:

    • When the folder is created, it triggers a flow which notifies the user(s) by email with the path.
    • The users can then copy this path, and open the Template in Power BI Desktop, and insert themselves the URL.

     

    This method is dependent on the number of users of course, if it's very limited it's simple and will work, otherwise it's not efficient.
    If you have many users, I don't think the template replication is the right method for the long run. Need to consider folder permissions and Dynamic RLS for sure.


    Pedro Reis - Data Platform MVP / MCT
    Making Power BI and Fabric Simple

    If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

    Find me at LinkedIn
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello pmreis ,

      This is the way I am doing it currently. However, I wanted to see if it's possible to automate. Primarily only two user are invlolved, so there shouldn't be a with permissions.
      Each dashboard created belongs to a different project.