Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have created a back-end power bi dataset, the challenge is I need to give some users build rights to the data model, but I also need to hide one table from those users. I try to solve the problem following the blog below. However, it does't work because when I open the table to hide in my tabular editor, I don't find the option "private" in the Option section. Has anyone hiding tables using tabular editor?
https://datakuity.com/2021/12/06/hide-tables-in-power-bi/
Solved! Go to Solution.
After some trying I figured out the solution.
1. open a new pbix desktop file, select Data Hub - power bi dataset - select the full backend data model.
* in the report view, you will see all the tables. This is fine. We can hide the table in next step.
2. select data hub - power bi dataset again. If you receive a alarm, select "add a local data model"
3. you will be led to select a Power BI dataset again, this time, pick the same backend data model
4. this time, you will be allowed to pick the tables you want to include in the new Power BI report. Simply untick the table to hide and continue.
After some trying I figured out the solution.
1. open a new pbix desktop file, select Data Hub - power bi dataset - select the full backend data model.
* in the report view, you will see all the tables. This is fine. We can hide the table in next step.
2. select data hub - power bi dataset again. If you receive a alarm, select "add a local data model"
3. you will be led to select a Power BI dataset again, this time, pick the same backend data model
4. this time, you will be allowed to pick the tables you want to include in the new Power BI report. Simply untick the table to hide and continue.
Hello @Jeanxyz ,
what you could do is create a power bi dataset and prepare the measures then publish it to power bi service and they could connect to it through connect to power bi dataset connector, in this situation they wont be able to view the data view in power bi desktop, they could only see the measures and the fields in the field view and see the data Model.
check this to know more https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
That's the last thing I want to do. I want to minimize the no. of Power BI data models to avoid maintenance work in future.
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |