Forum Discussion
need help
Hi All, Need your expertise suggestion and guidance on the below which iam facing. i have a 2 fact tables which are having 360 and 330 miilions of rows and iam taking these tables from sq...
Anonymous direct query isn't always good. Better to use import for performance wise. Can you give us a bit of context on what you trying to do with the data. I suggest filtering the tables with sql queries and don't pull the whole data. e.g., limit 100, filter recent date,etc.
Hi Ray_wu,
i have to create a power bi report using the sql queries which that much of Data.
Regards
Anitha.