Generate a report automatically with given data?

[carlosss897]

Hi , I have a usecase where my customer wants a automated self-generated report. 

My idea was it to built a template, where they can upload their csv files and it automatically fils all data within that report and after that, they can  check manually if the data is correct like that / change it by themselves. is this possible (with power automate?)?

I couldn't find a solution in the web, so I'm not sure if it is even possible. So the output is basically the pbix file, that would be enough

thanks,

carlos

[v-yangliu-msft]

Hi  @carlosss897 ,

You can consider using Power BI Automate to create a flow that is triggered when a CSV file is uploaded to a specified location. flow can then use the data in the CSV file to populate a Power BI report template, later retrieve the data in the CSV file, populate the report template, and later perform an export to a PBIX file.

This is the related document, you can view this content:

Extract information in Excel using Power Automate - Azure Cognitive Services | Microsoft Learn

Export and email a report with Power Automate - Power BI | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.