script to push content pack to users workspace

[ravikant_9]

We have integrated Power BI Reports with .net application and showing the reports in the existing .net Portal with Single Sign on enabled.

Issue: I have published the Power Bi Report and shared the content pack with the users. For users to see the report, they have to login to https://online.powerbi.com and import the content pack.

We are looking for script which can push the content packs to all the user's "My Workspace" with whom we are sharing the content so that they can directly login to the Portal and see their reports.

[v-yuezhe-msft]

@ravikant_9,

It is not possible to push content pack to all the user's "My Workspace" with script. 

In your scenario, you can publish the Power BI  Report to App workspace instead, then add the users as members of the App workspace, this way, when users login to Power BI Service,  they are able to see reports.

Regards,
Lydia

[ravikant_9]

Hi Lydia,

In our scenario, we do not want out users to login to Online Power Bi and check the reports. We have a customer portal where they will be loggin in. We want to give them good visualized reports with Self Service capabilities without any extra steps. So, we have designed the Reports, Published them and provided the RLS and shared the Content Pack. Also from the .net perspective, we have provided another Button on the Login Page. On clicking the Power BI report from their Workspace is opened with Single Sign On.

When I share the Content Pack, We have to ask them to import the content pack so that our .net application pick up the Report and show the same.

Is there any other solution which we can implement to achieve this scenario.

Please advise. I can give more details if required.

[v-yuezhe-msft]

@ravikant_9,

You don't have to create content pack. Why not directly use Power BI embed feature to embed report to your application? You can use RLS with Power BI embedded content.

https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security

Regards,
Lydia

[ravikant_9]

@v-yuezhe-msft

We are looking into that option as well. But as far as I know, I have to create an App Workspace for Embedded Power BI. Once I create members and assign Only View permissions, they will not be able to do the Self Service (Modify existing report/ Create new page and Prepare new report and save it.) functionality. 

If I assign the members as "Edit Content" also, then RLS is not working. In this case, if they modify the report, the shared report gets modified and everybody will see the modified report.

Regards,

Ravi Kant

[v-yuezhe-msft · Accepted solution]

@ravikant_9,

You don't have to grant permission for users in Power BI App workspace. You can control permissions for users in Azure registered app.

In other words, you are able to achieve the requirement that configure RLS for the embed report and grant user edit report permission at the same time. For more details, you can post the question in Power BI Developer forum to get dedicated support.

Regards,
Lydia