Forum Discussion

Anonymous's avatar
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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

//Need some suggestion on this to take data from SQL queries which has 660Million rows approximately.

If over 1 million rows are returned from Direct Query, Power BI returns an error (unless in Premium capacity, and the row count is under the admin-set limit) (1 million row limitation in direct query is the number of rows returned.)

Reference: Use DirectQuery in Power BI Desktop

 

Such queries can put a huge strain on the performance of data sources and reports. You need to optimize some queries, as Wu says, to filter out the required data.

DirectQuery model guidance in Power BI Desktop

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data