Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

Vote (582) Share
Andy's profile image

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)
Andy's profile image Profile Picture

Power BI User on 06 Jul 2020 00:00:59

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

yes, it is badly needed .

Andy's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:58:35

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

This feature is badly needed for compliance and source control. We don't want to checkin the pbix with data owing to compliance.

Andy's profile image Profile Picture

Peter van 't Klooster on 05 Jul 2020 23:57:59

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

I don't know Powershell, I myself had VBA in mind but the same idea.

Andy's profile image Profile Picture

Power BI User on 05 Jul 2020 23:48:29

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

This feature would seem to impact any Power BI customer that has more than just a few reports.

Andy's profile image Profile Picture

Power BI User on 05 Jul 2020 23:42:17

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

This is so important for Continuous Deployment and Quality Assurance

Andy's profile image Profile Picture

Charlie Blake on 05 Jul 2020 23:40:47

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

This is badly needed. Please Microsoft this should be implemented

Andy's profile image Profile Picture

Charlie Blake on 05 Jul 2020 23:40:47

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

Please Microsoft this is badly needed

Andy's profile image Profile Picture

Antoine on 05 Jul 2020 23:39:55

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

Would be really helpful to avoid having to export huge files with the API !

Andy's profile image Profile Picture

Sam T. on 05 Jul 2020 23:39:29

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

This is essentially what the previous commentby Karl Beran refers to in the documentation of the Export-PowerBIReport - but without the data. We would really like to export the definition of the report, which we could archive and maintain under source control, and be able to upload it later and then refresh to get all the data.

Andy's profile image Profile Picture

Ruslan Zolotukhin on 05 Jul 2020 23:31:11

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

It is a good idea also if your online file is quite big and export to PBIX can take much time because of location difference, network etc.

Merged Idea (7)