cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
efonsecab Frequent Visitor
Frequent Visitor

Which options are there to automate this specific scenario

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.

2 REPLIES 2
Moderator Eric_Zhang
Moderator

Re: Which options are there to automate this specific scenario

@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。

kartikg2jee Frequent Visitor
Frequent Visitor

Re: Which options are there to automate this specific scenario

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 308 members 3,618 guests
Please welcome our newest community members: