Forum Discussion
Excel Pivot Table based on Power BI Data Model
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?
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.
2 Replies
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/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.
