Forum Discussion
Helper IIIRedundant tables in model
Helper III
- Yes. All 10 tables contain same columns. 70 columns in each table
- A few columns that are not needed, I have removed in Query Editor, as I have mentioned in my intial post.
- I cannot exclude any rows. It's all production data.
The 10 tables come from 10 people from 10 departments. Earlier each department had it's own report so it worked well.
Now, our clients need a common report for all 10 departments. Hence, the need to merge data in a single report file.
I want it to make as simple as possible for them to upload their reports. All data manipulation is to happen after the data is pulled in Power BI.
So, the intent is, they will have to only dump their report in the excel without doing any changes themselves; Power BI will pull all the data, make transformations and build the common report. This is a monthly thing, and people come and go; so I want to eliminate any mistakes and make it as straightforward to dump data as possible.
Thanks for taking time to read and willing to help out. Truly appreciated!
Super UserHi Enigma
Now you can save couple steps and work on 1 table from the beginning
1- if you connect power bi to your workbook you will have to check all sheets and import them, this will display 10 tables, what I suggest you to do is to import only one sheet 🤔, Yes only 1 sheet.
You will get then the below preview
2- in the steps tab select the 1st step and you will able to expand data from all sheets without loading all sheets or append them
3- in this table you will need to add couple transformations to clean rows and keep the needed columns
Does it work ? Mark it as a solution
A kudos would be appreciated
- Enigma
Thanks for suggesting DataVitalizer - I will try it out and get back if it worked.