Forum Discussion

AnupTandale's avatar
AnupTandale
New Member
1 year ago

Unable to load data from batabase using kusto query

I am trying to load data in power bi but unable to load  Kusto query -  // -- Helper functions let GetColumnValue = (column_id: long) { database('db1').GetLatestSnapshotView(project_column_values...
Need Help
AnupTandale's avatar
AnupTandale
New Member
1 year ago

Hi DataNinja777 ,
The total number of rows in the table is around 87 million, which is less than 1 billion. However, is it still possible that Power BI is unable to load the data because of large number of data?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi AnupTandale,

    Thanks for the reply from DataNinja777.

     

    To be honest, YES, Power BI might still struggle to load 87 million rows due to hardware limitations, inefficient data models, or configuration constraints, even though the row count is below 1 billion. 

     

    You could optimize the data model like removing unused columns, leverage the Incremental refresh to keep the recent data, or you could upgrade hardware directly. Use a machine with 32+ GB RAM and an SSD for smoother performance.

     

    Best Regards,
    Qi
    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!