Forum Discussion
Virtual table or actual table
Hi all,
I need to create a fact table with aggregated number. I could do it using summarizecolumns function on basis of a couple of exsiting tables in my power bi book or directly import the same data from SQL server (all data comes from the SQL server).
I'm not sure which way is better in terms of performance or otherwise.
Any advice would be appreciated.
Thanks
Yong
Hi Anonymous ,
Depends on the size of your data and the tranformation you would do in desktop.
If "import" all the data would occupy much memory and storage and not all the data is needed,I would suggest you consider using dax expression.
If you need all the data for transformation in power query,I would suggest you "import".
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
4 Replies
Anonymous , You should power BI Aggregation using manage Aggegation in Data View, There you can use the same table at different level.
This is an example. https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations
Or
Hi Anonymous ,
Depends on the size of your data and the tranformation you would do in desktop.
If "import" all the data would occupy much memory and storage and not all the data is needed,I would suggest you consider using dax expression.
If you need all the data for transformation in power query,I would suggest you "import".
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
