Forum Discussion

Anonymous

Not applicable

4 years ago

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...

Memorable Member

4 years ago

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.

Anonymous
Not applicable
4 years ago
Hi Ray_wu,
i have to create a power bi report using the sql queries which that much of Data.

Regards
Anitha.
- RayWu
  Memorable Member
  4 years ago
  there is a limit of 1m rows data.
  https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#other-implications
  
  Not sure if the premium will increase the data capacity but either way you will have to filter down the fact tables, there no way you can load them into the report visual and even if it did the performance would take a long time to load. The only way i can think of is to optimize this query, such as using filters