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.
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.