Power BI
Needs VotesPowershell automation to create new pbix files from templates (pbit files)
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 (78)
- Merged Idea (7)
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 !
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.
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.
RE: Powershell automation to create new pbix files from templates (pbit files)
along the lines of https://msdn.microsoft.com/en-us/library/mt826236.aspx
RE: Powershell automation to create new pbix files from templates (pbit files)
This would also help from privacy compliance perspective. We don't want old data to stay in the file.
RE: Powershell automation to create new pbix files from templates (pbit files)
This would also make working with PBI in source control dramatically easier. 1+ gig datasets don't play nicely on any source control platform and the pbit workaround is not ideal at all.
RE: Powershell automation to create new pbix files from templates (pbit files)
https://powerbi.microsoft.com/en-us/blog/upload-a-local-pbix-file-using-the-import-api/
RE: Powershell automation to create new pbix files from templates (pbit files)
'Yes the ability to upload .pbit files with REST API + passing parameters on the fly would mean we can auto-populate new client projects using Embedded with a standard PowerBI report but with parameters specific to that client. Like the URL or connection string to their data.
I can see that reports are now supported in Beta, to me this is less useful. My data can all be pulled in a refreshed through PowerBI Web so uploading the dataset is meaningless.
- Upload template
- Supply parameters
- Return ReportID for my app to use
- Refresh data immediately to populate report
- Allow me to set refresh options on the report or set it for the group or something
= Automated standard reporting for multiple clients using Embedded