Access PowerBI with current permissions in Project for Web

[PowerBIusername]

Hello,

I use the Project Accelerator within Project for the Web. I'm rolling out project accross the organization. Project accelerator has a PowerBI template that is shared within the Accelerator Solution.

The problem is I published the reports and I can see all projects across all departments. I would like it to behave like a .pbit file where is uses the users access.

Is it possible to force a pbix report to refresh using the current users access? I applogize, I'm not a heavy user of PowerBI

[Anonymous]

Hi @PowerBIusername ,

Do you want to configure user access for the Power BI template deployed to the Accelerator solution? If so, you need to deploy the Power BI template before deploying it to Accelerator solution.Share Power BI reports and dashboards with coworkers and others - Power BI | Microsoft Learn

1. Import Power BI template to Power BI Desktop.

2. Publish the report to workspace.

3. Manage permission of report in Power BI service.

• In the report's row select the three vertical dots to open the menu, and then select Manage permissions.
• Under Related content, expand Datasets, and then select the report.
• In the Grant people access dialog, enter the email addresses of the Teams groups who need access, select the sharing options you want, and then select Grant access.

4. Add a Web resource that embeds the Power BI report.

• Once you've deployed the Power BI template, open the report in PowerBI.com.

• Select File > Embed Report > Website or portal.

• Copy the link labeled Here's a link you can use to embed content and keep it handy.

• Use the copied URL to deploy the report to the Accelerator solution.

If you need to configure users to have more accurate access to data, you can try the RLS @TomMartens mentioned.

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

Best regards,

Mengmeng Li

[TomMartens]

Hey @PowerBIusername ,

I'm not familiar with "Project for web", but not sure what you mean by "refresh." If you are talking about importing data, then most probably, it will not be possible because "there" will only be one semantic model inside a workspace. For this reason each and every time a user is initiating a model refresh the data will be overwritten by the current's uers access permission.
I suggest that you consider implementing row level security: https://learn.microsoft.com/en-us/power-bi/guidance/rls-guidance

Hopefully, this helps to tackle your challenge.

Regards,

Tom