CODEWITHSUNDEEP
javasql-serverdatabasejmeterpowerbi
Priyankara
Priyankara

Reputation: 21

How to do performance testing for Power BI dashboard project using jmeter?

Since power BI request are not recording i was set up a profiler on the server and took the dax querys from the profiler and try to run it through the Jmeter. My questions are 1) Can wedo performance testing using jmeter in power BI projects? 2) Can we connect to the Analysis services to run the Dax querys?

And when i m trying to connect to the Analysis services i m getting below error massage. connection error

Connection properties with values

Upvotes: 1

Views: 4575

Answers (1)

Dmitri T
Dmitri T

Reputation: 168147

My expectation is that you're using wrong driver. Given IntegratedSecurity=true I think you're trying to login with current Windows user, therefore:

  1. Remove JTDS driver from JMeter
  2. Download Microsoft JDBC Driver for SQL Server
  3. Drop sqljdbc42.jar somewhere to JMeter Classpath
  4. Drop sqljdbc_auth.dll file from auth folder of the JDBC Server installation to JMeter's "bin" folder (or somewhere under Java Library Path)
  5. Restart JMeter to pick the .jar and the .dll up

Assuming everything goes well you should now be able to connect. Just in case check out The Real Secret to Building a Database Test Plan With JMeter article to learn more about databases load testing.

Upvotes: 1

Related Questions