is it possible to limit powerbi iframe based on logged in user variable?

(0) Share

Report

Posted on by GeorgiGeorgiev

I have a portal that has 2 pages. 1 page for users marked as Customers and 1 page for users marked as Carriers.

In the Carriers page I put a PowerBI report that includes data from a local database.

Is it possible to take a variable from the logged in user on the Portal and limit his visibility on the powerbi report?

To explain a bit more: I am carrier Tesva. I log in on the portal, open the Carriers page and see the powerbi report showing data only for me, Tesva and not showing all the other data for other carriers. The setup would be: unique identifier for the carrier in the DB, then in power portals another identifier for the user to match with.

In sql I would limit this in the WHERE clause with an identifier that is in the database against 1 or more carriers.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @GeorgiGeorgiev

You can use RLS with Power BI to achieve this. I have answered in the following post.

https://powerusers.microsoft.com/t5/Power-Apps-Portals/PowerBi-Integation/m-p/1206390

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
GeorgiGeorgiev 93 on at

Like (0)

Report
Copy link

Link copied!

Hi @ragavanrajan , Thank you for the answer. This would be helpful if I want to limit 2 or 3 users at level Carrier or Customer. But in my case when I need something more dynamic, for example 50 users that are Carriers or Customers and each one to be able to view only their records from the report, it would not work easily. I would have to create a separate role for each user I have in Portals.

EDIT: and also have 50 tables in the report.

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @GeorgiGeorgiev

Got it. No worries. You can still apply dynamic rls.

Have a look at the official docs

https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

You can apply username principal and apply dynamic rls. No need to create separate roles.

Hope it helps.

------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
GeorgiGeorgiev 93 on at

Like (0)

Report
Copy link

Link copied!

Hi @ragavanrajan ,

Thanks you for the link. This will be usefull when I need to limit people with powerBI or MS account right? Or at least I would have to have a role for each user, and this role will be limited to see certain rows. At least that is what I understand. This might be useful to me for another project.

In the current case maybe I would be better to implore SQL directly with power automate. Customers and Carriers will not have accounts on MS, but will be provided by us for the portal. It should be, I hope, a bit easier to use sql in a more direct way rather than going through powerbi as there wont be any graphs - just tables.

Was this reply helpful? Yes No