Forum Discussion

sang_kd2's avatar
sang_kd2
New Member
9 years ago

POwerBI performance measuring tool

Hi, 

I want to measure performance of my application for PowerBI for huge data set say millions of record.

Is there a tool available to metrix Powerbi perf numbers?

 

Thanks

 

3 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    9 years ago

    sang_kd2 Not sure what you meant to measure in power bi desktop but if you want to know how fast can power bi load data then check out this link that says how fast can power bi load / refresh data based on subscription type. That is for power bi service though I dont think you should measure how fast can power bi refresh data in pbi desktop as its a designer tool and not ultimately where you will refresh data each day. 

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    You can use DAX Studio/SQL server Profiler to check the performance of your data model. More information on what you can do with DAX Studio is at here. 

    • sang_kd2's avatar
      sang_kd2
      New Member
      9 years ago

      Thanks , 

      We are showing reports in POwerBI rendering data from sql azure Table and Views.

       

      Views rendering report seems to be less performant than direct query from table -  which is kind of obvious from SQL point of you.

       

      Wanted to understand if there is POwerBI limitation on showing report fetching from VIews vs tables ?

      Or there is way to mointor perf numbers for POwerBI.

       

      Sql profiled helps at sql query level.

       

      Thanks