March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
36 | |
27 | |
19 | |
11 | |
8 |
User | Count |
---|---|
55 | |
43 | |
25 | |
13 | |
12 |