Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Converting Dimension multiple tables to one master table

Hello Team,

 

I have created a dataflow with one Fact table and there are multiple Dimension tables in it.
I pull the tables and create the relationship between the tables. However, when I go to report tab, i can see that there are multiple tables in it. Is there anyway we can create one master table with the required columns from Dimension tables?

2 Replies

  • Anonymous , remove the columns that are not required in dataflow or power query

    • Anonymous's avatar
      Anonymous
      Not applicable

      The extra columns are the foreign keys.