Forum Discussion
Direct Query unstable performance
This problem still exists
Environment Windows 10. PowerBI Desktop Version: 2.91.701.0 64-bit (March 2021)
Problem realization;
* Open powerBI desktop. Open. pibx file which is connected MS-SQL via direct query
(MS-SQL server installed on my own laptop.
There is no other client to request anything off my database on my network.
Database is not being used to enter data or something else.
Laptop is not serving to another client for any purpose)
* Open performance analyzer. Start recording.
* Refresh visuals. Max duration(ms)=2005.
* Clear
* Refresh visuals. Max duration(ms)=2082.
* Clear
* Refresh visuals. Max duration(ms)=1896.
* Clear
* Refresh visuals. Max duration(ms)=13521.
* Clear
* Refresh visuals. Max duration(ms)=4091.
* Clear
* Refresh visuals. Max duration(ms)=2147.
It's really weird.