Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
ZikoPowerBI
Helper II
Helper II

Direct Query unable to process more than 1 Million records

Hi Team ,

 

I have a requirement to be incorporated in Power BI .

 

There are 3 Millions records for one date. We tried using Direct query to create a Power BI visual , but the response time of a specific visual is 1.5 Minutes which never be accpeted. In our dimension we have Country and Measure is Simple Sum(Sales) it is a normal bar chart.

 

We have 150 dates in all . Please help us know if direct query is not the appropriate in such scenarios.

 

We also tried using import mode and the refresh takes around 14 hours to bring in all 150 dates ( This option is also ruled out) 

 

We tried Incremental load , but eventually the PBIX file size reaches 20 GB and eventually does not open up in power BI service as we append recent data everyday.

 

Any suggestions will be helpful.

 

Thanks!

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.