Forum Discussion

Max19's avatar
Max19
Advocate I
1 year ago

Unable to load the visual

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.

 

 

Need Help
Tips and Tricks

8 Replies

  • dbrowne's avatar
    dbrowne
    Microsoft Employee
    1 year ago
    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's avatar
      Max19
      Advocate I
      1 year ago

      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 

       



    • Max19's avatar
      Max19
      Advocate I
      1 year ago

      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's avatar
      Max19
      Advocate I
      1 year ago

      Hi dbrowne ,

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

      // Direct Query
      // Query




  • dbrowne's avatar
    dbrowne
    Microsoft Employee
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.