export from power bi to excel (wide tables)

[NunoTrigo1986]

Hei,

In our organisation we have several dashboards with different types of visualisations. Our data comes mainly from dimensional models where facts tables ares of type "long" table. When our analysts export data from these different kinds of visualizatins they get longtables. However what they need to perform analysis is human frindly tables (wide tables). is there a "quick" way to assure that they get wide tables so they dont need to use time transforming from long to wide ?

[pbiuseruk]

I would suggest modelling your tables firstly, then putting in all of the fields as necessary into a table visual.

Then export the table and it'll be in the same layout automatically.

[NunoTrigo1986]

• hi and thanks for your reply. Do you mean I should model the wide tables before using it on a table visual on power Bi ? is that feasible ? thanks in advance

[pbiuseruk]

I meant if you've got a typical fact table i.e. A primary key column/columns and then multiple FKs to different tables.

It would be good to model it first in the modelling tab.

Then you can pull through all of the looked up fields (from your dimension tables) into one wide table which is human friendly (and won't just be random ids).

Then you can export this.

Hope that makes sense.

[lbendlin]

There's an option to "export with current layout"  from Matrix visuals. That might work for you.

[NunoTrigo1986]

thanks for your reply. i didnt know about that so it sound a good idea. now i am wondering if is just mateix that has this festire or there any other visuals ?