Automating Power BI for report modification / generation

[hoss]

Hi all,

I'm faily new to Power BI. Was wondering if there is any scripting shell available for Power BI to automate repititive tasks in report modification / generation? Stuff like: delete every page that starts with X or move the visuals with name X down the page by Y pixels... Hope you get the idea.

Thanks.

[Anonymous]

Hi @hoss,

If you mean the embedded power bi contents, it is possible to use javascript API to control its reports and visuals. You can take a look at the following wiki of power bi javascript.

microsoft / PowerBI-JavaScript 

Regards,

Xiaoxin Sheng

[hoss]

Hi @Anonymous , thanks for the resposne. No I'm talking about automating report creation and modification in Power BI Desktop. For example a task could be: opening a pbix file, running a script that deletes some pages and saves the pbix file as a new file. 

[Anonymous · Accepted solution]

Hi @hoss,

It sounds like you want to directly use the script to change the internal contents of a pbix file. AFAIK, current these features not supported on power bi desktop side.
In my opinion, I'd like to suggest you design a report and parametrize its connection string to save it as a template. Then you can simply open and modify the template designs to quickly generated some different versions of the report.

Deep Dive into Query Parameters and Power BI Templates 

BTW, if you mean to edit the report contents without using the power bi desktop client, you can also take a look at the third-party tools. (e.g. tabular editor)

Offline model editor experience for Power BI 

Regards,

Xiaoxin Sheng