Unable to load the visual

[Max19]

Hi,

I am unable to load visuals for donut chart & matrix chart . I have experienced the following error. Could someone please assist or suggest any solutions for the same.

[Anonymous]

Hi @Max19 

Based on your description, please check thay if your query is too complex, you can consider to break the query into multiple queries, you can refer to the following link.

MSSQLSERVER_8623 - SQL Server | Microsoft Learn

You can use sql profile to trace the action in power bi.

Configure SQL Server Profiler as an External Tool ... - Microsoft Fabric Community

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dbrowne]

If you hit Copy Query it will copy both the Dax and SQL query.  Looks like the SQL is either slow or returning too many rows.  You can use Dax Studio to analyze the performance of the DAX query.

[Max19]

Well there is one matrix visual and Donut chart for which I could not generate a query from the optimizer.
How do I analyze that in the studio?

[dbrowne]

https://www.sqlbi.com/articles/importing-performance-analyzer-data-in-dax-studio/

[dbrowne]

That looks like SQL Server error number 8623. So is this a DirectQuery model? If so troubleshoot with the PBI desktop performance analyzer and see what kind of SQL queries it's generating.

[Max19]

Hi @dbrowne ,

I have checked the performance analyzer and I could see that it is generating direct query and normal query

// Direct Query
// Query

[Max19]

@Anonymous @dbrowne , I am maintaining a direct query and trying to transform one of the column with a space as delimeter using the EXTRACT option. This says the query is not supported in Direct query mode.

Could you please suggest any other way which is supported in direct query?

[Max19]

It is direct query connection only. I have checked the performance analyzer. Could you please be specific about it (see what kind of SQL queries it's generating).
FYI, please find the snippet below

Also, following is the error message for the visuals which are not loading. I have applied all the possible filters. Yet, I could not load them. I am able to generate for