Power BI threads causing server crash in IBM PA
Hi team,
I am working with Huntsman, and we are using Cubewise tools like ARC, Pulse and Connector for Power BI.
In previous month we faced an issue where a user was trying to open a view in Power BI using mdx query generated in IBM PA cube view.
He unintentionally opened 17 such instances and these threads were running in IBM PA even after user disconnected the session in Power BI. This caused threads to go into wait mode (including security refresh and save data) and server was in unresponsive state. The only option left was to restart the IBM PA instance. Due to this issue the server was not available for 600 minutes and there were some cubes where user reported data loss.
Can your team please check what caused issue with Cubewise connector for Power BI ?
We have already raised this issue with Cubewise consultant Guido Tejeda gtejeda@cubewise.com, Logging an official ticket.