- Windows Server 2016 DataCenter - SQL Server / Analysis Server 13.0.1742
- On-premisis Gateway 14.16.6724.2 (june 2018)
- Power BI Desktiop 2.59.5135.781 64-bit (june 2018)
Our power bi reports are using the data (cubes) from the analysis server.
If we are usng the visualisation "Table" and add mutliple fields from tables (combination of measures and normal fields) then very quickly we get an performance issue (crash) when visualising a lot of records.
The same performance issue happens when we use the "Table" as the result of a "DrillThrough" functionality. Even if the result of the DrillThrough should show only a few records - it crashes.
No data is displayed, we keep seeing the 'hourglass' for minutes - memory on the sql server is going up through the roof - when out of memory we get an error in Power BI - it even happens that our Windows Server 2016 hangs and needs to reboot.
Very strang for such (from my point of view) simple functionality.
If I copy/paste the page in the report and replace "Table" with "Grid from MAQ Software" then everything works correct and quick. So my conclusion is that the visualisation "Table" is not ok.
Please advise how to proceed.