The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi community!
I followed the instructions to embed a report into an internal webpage (in this case Atlassian Confluence) by following these instructions. I used a javascript to extract the currently logged in user and pass in the email address as filter parameter using this snippet:
<center> <script> var epic = "PAPL-616" var content = "https://app.powerbi.com/reportEmbed?reportId=ad34739c-e72b-43f5-945c-2767c692358f&autoAuth=true&ctid=ed1bc7bc-9e75-4836-9e38-7a4c7f7273d2&filter=Jira_x0020_Epics/issue_x0020_key eq \'"+epic+"\'" document.write("<iframe id=\"iframe\" title=\"PowerBI reporting\" width=\"1200\" height=\"900\" src=\""+content+"\" frameborder=\"0\" allowFullScreen=\"true\"></iframe>") </script> </center>
My problen now is that the deep link provided doesn't get used on different pages of the report since every page of the report has it's own deep link. I'd love to use the same filter on multiple pages of the report (currently I'm obviously using only one page).
The practical background is that we have a bunch of project managers who will all maintain their individual project webpages (Confluence). Every project manager gets identified by their email address and the commonly shared dataset over all projects of the oganization gets filtered by that email address, so the project manager only sees a predefined project on each project website.
To make things clear: I would love to have a commonly shared deep link of the PBI report itself. The parameter pageName doesn't work anymore, see the instructions link given. I'd love to have that ability, again.
Please kindly share your thougts and vote for the issue.
Thanks
Hi @rudisoft
What I would do is to use Row Level Security, which means when the user logs in they would then only see their data related to their name
By doing this you would not need to filter any of the data.
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
53 | |
22 | |
11 | |
10 | |
9 |
User | Count |
---|---|
113 | |
33 | |
28 | |
19 | |
18 |