since the December '18 Update of PowerBI Desktop the IBM DB2 Connector works really very slow. Loading data into the model starts fast but gets slower to a point where you get the feeling that you can count with it. Some querys aren't loading at all, all they'll do is "Evaluating". I already opened a Support-Ticket at Microsoft wich they closed with no further notice. I posted this Issue in the community-board and one (!) person said, that he's having exact the same issuses.
The scheduled refreshes in the service don't finish. Cause is a Time-Out. The Error-Message occures 2 hours after the scheduled refresh in the refresh history.
PowerBI Desktop December '18 and Gateway December '18 are used. During the refresh the cpu usage of my client rises to 95 - 100 % and PowerBI Desktops creates three Mashup Evaluation Containers. RAM-Usage is at ca. 64% (8GB installed).
Before the December Update a specific Report with 8 Querys took about 1 - 2 Minutes to refresh. Now, i can leave my client for the rest of the day and when i return all the querys are still running. I had to exclude one Query from refreshing cause all it was doing was to "evaluate" wich put the other queries into a "waiting" line.
The crazy thing about this is: If i use the exact same queries (copy - paste the syntax) in Excel, it runs as fast as before the December Update for PowerBI Desktop.
Has anybody else got the same or a familiar problem?