topic Re: Which options are there to automate this specific scenario in Developer

Which options are there to automate this specific scenario

efonsecab — Thu, 15 Sep 2016 21:57:29 GMT

We have a system which uses Power BI for cutomers to check data.

Reports invoke SQL Server functions with parameters changing per client, currently their Twitter Username,
so reports are the same except for the parameter.

The current deployment approach is to manually create a template, then when a new client arrives, open the template, change the parameter save and publish the report for that specific client.

We'd like to automate that process in this way

* User creates and account on our website by logging in with Twitter

* System starts creating the reports with the modified parameters to reflect the client's user.
* Publish the report ( either on a new Group within our tenant, or the ideal scenario: publishing on a new group in the client's tenant)

Is there any way to automate this process from Power BI, I have checked the API but it seems very limited at the moement.

Re: Which options are there to automate this specific scenario

Eric_Zhang — Mon, 19 Sep 2016 02:48:35 GMT

@efonsecab

Are you aware of Row level security in Power BI? It seems exactly what you need. You can hold the report for all users in your group, add the users in the group(member read) and assign them proper roles. Then no effort is required on automation.

Regarding "System starts creating the reports with the modified parameters to reflect the client's user", as far as I know, so far there's no approach to access and modify a pbix file programmatically。

Re: Which options are there to automate this specific scenario

kartikg2jee — Thu, 23 Nov 2017 09:06:51 GMT

Its been a year since the question was asked . SO I am interested in knowing if we can programmatically create and publish reports.