SLOW Power BI Online Dashboard

[taiyun]

My organization is experiencing really really slow performance when dashboards is published to the web. On the desktop version, it is running fine. I m using directquery. My datasets are huge, there are join queries and one or 2 of the tables have more than 23 million rows.

I have already reduced to the columns i needed. I cannot use import as it is over 1024 mb when publishing. My data resides on Azure Data Warehouse.

My data warehouse right now is using default number of DWUs. I want to know if increasing DWUs will help with directquery.

The speed is so bad that i am getting 'X' white boxes for my graphs saying that there are not enough resources to load the graphs.

[v-qiuyu-msft]

Hi @taiyun,

It seems the issue about Power BI service itself. I would suggest you create a support ticket to contact Microsoft for dedicated support.

Best Regards,
Qiuyun Yu

[Anonymous]

Performance is very poor in direct query. you can check again by increasing DWU. 

[taiyun]

Thank you for your response.

May I have someone from microsoft to also verify this?

Since i would need to pay for additional DWUs, i need to have a confirmation that it WILL give me a better runtime when i load my dashboards online.

[taiyun]

Actually, I am pretty sure increasing DWUs will not help now. Since my on-premise server could access the data, hosted on zure DWH, fast enough for the dashboards on desktop version. It only becomes a tortise when published. I am suspecting it is a latency issue, communication between Power BI to our Azure DWH, which is hosted in SEAA. 

Anyone from microsoft can verify this?