Forum Discussion
Data Modeling - is it worth to create a star schema?
Helper ICan you access the same Data using SQL/Database? The best approach would be to have a table for each of your dimension.
The refreshing takes time because you are using the same 43K Datasource when generating each of the dimensions
If you are using a Star schema, the compression of your model will better and result in a smaller Pbix file.
A smaller file will always imply a better performance when doing a scan on a table. Of course, for a model containing a Fact table of 43K rows, it might not have a big gain in performance.
Always remember to lower the number of columns in your table (especially the Fact table). Remove columns with high cardinality (number of distinct values) if you don't need them.
Thanks for the tips!
I'm not creating a connection to a database, but a CSV file.
I managed to duplicate the source only twice, my performance is way much better now!!
I'm going to create a few dim tables using DAX instead of PQ (:
m3tr01dContinued Contributor
Anonymous Ok, sounds good,
Try to avoid SummarizeColumns when creating this table and be careful if you use VALUES Function, you might have Circular dependency error when creating the relationship.