Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
From the link below, I understand you can set a filter in the report then share the report (with the filters) to other users.
We currently distribute our PBI through the App function, therefore the above will not be possible? Is there an alternative method I can distribute pre-filtered reports?
Many thanks!
hi @swwong1 - Can you please share the exact requirement for sharing pre filtered reports - but here are the options you should consider
As mentioned by @darentengmfs - if it for security reason so certain users can only see certain data then you should explore the option of RLS as per the Microsft documentation
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
If you require to show particular snapshots to users then you can explore the option of bookmarks - Power BI service generated unique URLs for each bookmark view. Below is the Microsoft documentation for creating bookmarks
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks
https://www.youtube.com/watch?v=hEAtbGrlKhY
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
Thanks @Sumanth_23
Let me have a look at creating bookmarks - I already do this personally but haven't shared my bookmarks to other users
As an example, I want to send the performance of project A and B to a sales manager (the RLS is already configured). Instead of them going into the PBI App and select the two filters, I will send them the link where the report is already pre-filtered to project A and B.
Based on the above, it seems like the bookmarks function work- let me have a read on this
Thanks
hi @swwong1 - yes, in your scenario I think bookmards would be a good option.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Sumanth
Proud to be a Super User!
Hi @Sumanth_23
I have read through the guide but it doesn't seem to mention I can share my bookmarks as a link to other users? Unless I am reading it wrong.
It just says I can create bookmarks at a report level and users can access these bookmarks if I am using pro version?
hi @swwong1 - Once your reports are published to the service you can share the URL for specfic bookmarks of your reports with Users as required - see below screenshots for reference.
Snapshot #1 is the default URL of the published report
Snapshot #2 is the URL a particular bookmark in my report
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
Thanks @Sumanth_23 @ let me check this tomorrow.
Forgot to mention, I am accessing the data through the app function so I cant access the report(s) at a report level.
Hi @swwong1,
Did Sumanth_23 's suggestion help with your score? If this is a case, you can consider to accept his suggestion to help users who faced similar requirements. If not, you can feel free to post here with detailed information.
Regards,
Xiaoxin Sheng
hi @swwong1 - I didnt get the last comment you made - you mean you are accessing the reports through Power BI apps?
Proud to be a Super User!
If the users in your App should only view certain data, you should try Row Level Security. Take a look at the article.
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |