Excel Pivot Table based on Power BI Data Model

[tsunami]

I have a very huge Power BI Data model that was imported into Excel as a Pivot table. Is there anyway to control the number of tables shown from the model.

We typically use pivot tables in our business and recently started using PowerBI, however for our pivot table users we want them to utilize the existing model but only seeing the facts and dimensions that are most pertinent to them.

How can this be achieved?

[Anonymous · Accepted solution]

@tsunami 
You may hide the tables, right click =>hide. After you publish to service, you will not see the those tables in the dataset. 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@tsunami , You can create pivot table like feel using Matrix visual -https://youtu.be/M5PvQUy-L_4

or https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

If you want to use a pivot table of excel , better you unpivot it in power bi

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/