Hi! I have a data model in PowerBI but am getting errors on some excel files because they contain extra columns. My client said some files have a couple more coilmns because they started collecting additional data over the past couple of years. How do I get the data model to match up the various columns that are in different positionsaand also allow for the additional columns to show up for the newer files? (Note: There is one excel file per week per year for 7+ years, so I don't want to have to do any manual edits to these excel files. Each Excel file has one table. All the tables are named the same, e.g. "VAorders".
If you are appending tables. Your columns name have to match. The order should not prevent you from appending the tables. If column exist outside of the append there could be issues. Appending is generally done to add new data to an existing table with static columns. You may need to create a data model that references a dimension and filters the data from these tables. This is just an assumption based on the limited information given.
Great video keeping it simple. I have many sheets to append and I want a column of sheet name in append table...What is the easy way, I can't just add custom column to each sheet?
The link used in the video: en.wikipedia.org/wiki/Wikipedia:WikiProject_National_Basketball_Association/National_Basketball_Association_team_abbreviations
This is straight to the point, and well explained. Thank you!
You're welcomed!
Excellent job. I did learn something that I didn’t know before. Thank you
This is great, like how you explain things/keep it simple. Keep going, thanks!
I loved the ending when you showed that Kareem's Table was better than both Lebron and Michael's combined.
Lol. Thanks for that. I am a basketball newbie but I love the stats.
Just what I was looking for. Thanks!
Thanks for the video. Very helpful and easy to follow
Great job explaining! Thank you for sharing😁😁😁
Thank you. On point
This was really helpful! Thank you!
Awesome 👍
Thanks 🤗
You sir are a hero
Awesome!
Really helpful!
Great video. Thank you!
EXCELLENT!!!!!!!!
Very helpful, thanks! :D
Great video, ty!
hi bro, could you help me how to cut part of coloum and move to new coulomn in the same file?
You can use the Split Column feature. This will create columns based on your split.
nice and easy
This has certainly helped, thank you...
Hi! I have a data model in PowerBI but am getting errors on some excel files because they contain extra columns. My client said some files have a couple more coilmns because they started collecting additional data over the past couple of years. How do I get the data model to match up the various columns that are in different positionsaand also allow for the additional columns to show up for the newer files? (Note: There is one excel file per week per year for 7+ years, so I don't want to have to do any manual edits to these excel files. Each Excel file has one table. All the tables are named the same, e.g. "VAorders".
If you are appending tables. Your columns name have to match. The order should not prevent you from appending the tables. If column exist outside of the append there could be issues. Appending is generally done to add new data to an existing table with static columns. You may need to create a data model that references a dimension and filters the data from these tables. This is just an assumption based on the limited information given.
Great video keeping it simple. I have many sheets to append and I want a column of sheet name in append table...What is the easy way, I can't just add custom column to each sheet?
yes you can add a custom column to each sheet
The link used in the video:
en.wikipedia.org/wiki/Wikipedia:WikiProject_National_Basketball_Association/National_Basketball_Association_team_abbreviations
For 2 Big Tables working ??? What is limits ?
I believe a single table has a limit of 1GB. Appending any tables would be limited to this size.
Get a pop shield