Forum Discussion
Consolidating PBI Desktop files, Creating/Sharing more than 1 dashboard
Exactly !!
You will have to repeat the process of deletion every time you publish.
Also, it is risky if you look at data security point of view.
Suppose User 1 is currently viewing his report and you publish the report at that time, if he refreshes, he will be able to see the other 10 tabs and wonder :D Meanwhile, you will hurry to open the report in Power BI online and delete pages one by one.
So practically not good idea.
If you still want to try this then make sure you un-pin your report from the user dashboards > Publish your file > Delete the tabs and then pin again so that atleast User data is not compromised.Thanks!
Memorable MemberHI a-kachua,
Answer 1:
As of now, there is no way to consolidate Power BI Desktop files (.pbix) i.e. you cannot copy/paste tabs from one report to other.
Regarding data refresh of the files, you need to manually refresh your on premise .pbix files. However, once you have published the report/dataset on Power Bi Online then there is option of refreshing it automatically on regular intervals.
Answer 2:
You cannot have tab level access for users. In order to achieve solution to this problem, you should create a single consolidated report for all the users (if the data to be shown is similar to all) and then take use of RLS (Row Level Security) which will help you in showcasing data at a single place and users can see data based on the access you provide. Read this for more details.
Hope it helps.
Thanks for the quick response to my questions, Prateekraina!
I have used RLS feature before, but as I understand it can be applied by selecting a field from my data tables and applying roles. But how do I apply RLS by page? Let's say I want a particular user to access only certain pages in my Power BI report.
Thanks!
- prateekraina
Hi a-kachua,
I am afraid you cannot have page level access in Power BI. There is no straight forward mechnaism other than RLS.
Although i have a bizzare suggestion for you :)
If you are so stressing to have a single report with say 20 tabs and then say User1 should have access to 10 tabs and User 2 to other 10 tabs.
> In that case have two separate workspaces, publish your pbix to both of them.> After that remove/delete the 10 tabs from each report by using Edit Report option in Power BI online and then pin the report on dashboard which can be shared with user.
I know this doesn't seem a legit approach but worth a try.
Hi Prateekraina,
Worth trying. Thanks for the suggestion.
Question though, if next month I refresh and publish my consolidated file again, do I need to go back to each workspace and repeat the removal of tabs from each report? Basically I'm wondering if the 10 tabs that I had deleted in the first workspace will re-appear after I publish my Desktop file.
- prateekraina
Exactly !!
You will have to repeat the process of deletion every time you publish.
Also, it is risky if you look at data security point of view.
Suppose User 1 is currently viewing his report and you publish the report at that time, if he refreshes, he will be able to see the other 10 tabs and wonder :D Meanwhile, you will hurry to open the report in Power BI online and delete pages one by one.
So practically not good idea.
If you still want to try this then make sure you un-pin your report from the user dashboards > Publish your file > Delete the tabs and then pin again so that atleast User data is not compromised.Thanks!