Forum Discussion
Solved
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 bu...
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.
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/