Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
30 | |
25 | |
23 | |
22 | |
21 |