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