Forum Discussion
Can Power Query handle this much data?
Jkaelinwhat are your data types in your facts? i really dont see an issue in combining them if they are most numerical, why doing you just try and see what happens? essentially its mostly up to your machine. and obviously because this is in memory technology you want to make sure you standarize your data as much as possible , the less unique values you have the better in order to get the most compression. Start only with what you need rather than everything.
Not sure why you would want to flatten something like that. That's like...the opposite of how this whole program is supposed to work.
What specific performance issues are you talking about?
Anonymous
I currently have a Snowflake schema. I've read that if I'm having poor performance it could be due to a lack of a Star Schema. I've read Star Schema's operate best via w/ flattened tables and fewer relationships. So I'm trying to flatten a few tables to help build an optimized Star Schema.
Am I doing it all wrong? I need help! I'm more of a finance guy trying to thrive in a data analyst world somedays.
Thank you!
James
