Is it possible to automate the creation of a report?

[Anonymous]

Hello, community, 

I am pretty new to PBI and I am working towards creating a fully automated system for external users to see reports.

The system stack so far is capable of extracting/creating/pushing datasets into a PowerBI workspace.

I would like to know if it is possible to automate the process of report/dashboard creation.

Is it possible when a new dataset is uploaded a new report based on an existing template is created?

The datasets all have the same columns but they do have different values.

Thanks in advance!

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Query Parameters allow users to easily make parts of their reports and data models. Templates allow users to export the definition of a report (report + data model + queries definition + parameters, if any) without including the actual data. Users can easily instantiate a Template using Power BI Desktop, which will ask them for parameter values (if needed) and create a new Power BI Desktop Report (PBIX file) based upon the contents in the Template file .

For further information, you can refer to the following links.

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/ 

https://workingondata.wordpress.com/2020/11/10/let-me-automate-you-take-power-bi-automation-to-the-next-level/ 

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