Create Power BI report from power automate

[Anonymous]

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?
 

[pmreis]

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]

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. 

[aj1973]

Hi @Anonymous 

You need to create parameters in Power Query for Folder Path string. 

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

[christinepayton]

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]

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.