Forum Discussion
Power Participanthow to hide a table from all users
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?
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.
3 Replies
- Idrissshatila
Super User
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 👍
- Jeanxyz
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.
- Jeanxyz
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.
