The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello!
I hope someone can help me 🙂 My organization is using microsoft dynamics and wants to embed a power bi report. The users that will view this report in MD365 won't have access to the PBI Service. So we want to set it up using the "app owns data" approach. The problem is that we need the users to only see specific rows. We can't use row level security with "app owns data" approach so my idea is that we will use the URL filters instead. So basically mapping of users and rows will happen on MS Dynamics side, a url will be generated that has the parameters that ensure the report is filtered in a way that everyone sees only the things they should see.
Is this secure? Is there any way a user could abuse this and somehow see the report without the URL filters?
Thanks!
Hi @MichalAdam,
Please correct me if I misunderstood what you meant.
1. Please check if the users accessing Power BI reports have proper license even Power BI Free license, if you don't register Power BI, you can't view the reports properly.
2. Please check if the users are given proper access rights on both Power BI and Dynamics.
3.URL filters are supported in Power BI Embedded. See Power BI Embedded advanced URL filtering capabilities for details.
For more you may also check Power BI Embedded integration - Finance & Operations | Dynamics 365 | Microsoft Docs
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
According to this - if I embed for customers then the users don't need a PowerBI account:
My idea is that I use embedding for customers and the embedded link will have some URL filtering that will work as security. The problem I have is I am not 100% sure if this will be secure (will the users be able to somehow see the embedded report without the url filters).
Best regards
Michał
User | Count |
---|---|
35 | |
14 | |
12 | |
11 | |
8 |
User | Count |
---|---|
44 | |
43 | |
19 | |
18 | |
17 |