Power BI

Needs Votes

Powershell automation to create new pbix files from templates (pbit files)

Vote (582)

Andy on 03 Dec 2017 13:56:06

Now that we have pbit files to help create new pbix files quickly it would be great to be able to automate this process.

Perhaps we could have some Powershell commands that would allow you to pass the needed parameters and output a new pbix file.

Comments (75)

easpect consulting on 06 Jul 2020 00:16:15

RE: Powershell automation to create new pbix files from templates (pbit files)

'+1 for this. We should be able to deploy PBIT separately and dataset separately.

Chris Vance on 06 Jul 2020 00:14:31

RE: Powershell automation to create new pbix files from templates (pbit files)

I'm working with a multi-tenant web app where each tenant has the same data structure. I need to upload a PBIT file to a central storage location, then copy the template into each workspace (1 for each tenant) and connect the data source to inflate the model. Uploading 300 to 500 PBIX files is not the way to go.

Power BI User on 06 Jul 2020 00:14:07

RE: Powershell automation to create new pbix files from templates (pbit files)

Definitely agree with publishing the .pbit file from a data security standpoint. Also my data source is a variety of SQL Stored Procedures which usually have parameters such as Start and End date. Depending on the range, they could retrieve anywhere from a few records to 500k records. And the data is constantly changing, so storing another copy of the data in the .pbix version makes no sense. It would be useless in a very short time.

Ronnie Li on 06 Jul 2020 00:13:36

RE: Powershell automation to create new pbix files from templates (pbit files)

It would be safer if we have the option to publish the metadata file (.pbit ) only.

K V on 06 Jul 2020 00:13:28

RE: Powershell automation to create new pbix files from templates (pbit files)

'+1. Definitely needed for enterprise PBI practices

Power BI User on 06 Jul 2020 00:11:36

RE: Powershell automation to create new pbix files from templates (pbit files)

Badly needed

Alan on 06 Jul 2020 00:10:55

RE: Powershell automation to create new pbix files from templates (pbit files)

agree with the comment on better enabling source control, as well as not storing large/sensitive data within the source control system. Being able to deploy a PBIT file or being able to auto inflate it would be a huge step in being able to automate fully the deployment of reports.