Forum Discussion

frithjof_v's avatar
frithjof_v
Community Champion
1 year ago
Solved

Performance: Real time dashboard vs. Power BI report DirectQuery to KQL

Hi,   In theory (and practice), is there a performance difference between a Real Time Dashboard and a Power BI report with DirectQuery to the same KQL source?   If yes, what are some main drivers...
real-time dashboard
  • datacoffee's avatar
    datacoffee
    1 year ago

    Someone might kill me for writing this. 

    the Power bi engine is not as fast as the Kusto engine to handle data.

    with this said, then power bi tries to fold all queries to the Kusto engine for it to do all the work. Query folding from power bi is happening more often towards the KQL engine than the sql engine. 

    so in theory the rtd would be more effective and performant  when working with Kusto data than power bi. But I don't think you u will be able to measure a real experienced difference 

     

    cheers

datacoffee's avatar
datacoffee
Most Valuable Professional
1 year ago

Someone might kill me for writing this. 

the Power bi engine is not as fast as the Kusto engine to handle data.

with this said, then power bi tries to fold all queries to the Kusto engine for it to do all the work. Query folding from power bi is happening more often towards the KQL engine than the sql engine. 

so in theory the rtd would be more effective and performant  when working with Kusto data than power bi. But I don't think you u will be able to measure a real experienced difference 

 

cheers

  • frithjof_v's avatar
    frithjof_v
    Community Champion
    1 year ago

    Thanks!

     

    Yes, I am assuming that the required DAX -> KQL conversion will make the Power BI report a bit slower than the native KQL Real Time Dashboard.