Forum Discussion

Clampazzo's avatar
Clampazzo
Resolver I
3 years ago
Solved

Can't load the data for this visual, internal error

I have a rather simple model.  A fact query that is a direct query and then I have a time dimension that is created via PowerQuery and is joined onto the fact table by a seconds column that is an int...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi ,  Clampazzo 

    According to your description, you are using direct query mode in Power BI Desktop.

    And when you filter the visual you encounter the error code "Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.".

     

    First of all, when we use Direct Query mode to connect to the sql server, then all queries on the visual object, including the measure you write, will be converted into corresponding SQL statements and sent to the data source for query. And this error message is the error message on the SQL SERVER side's limitation:
    This issue occurs because SQL Server limits the number of identifiers and constants that can be contained in a single expression of a query. This limit is 65,535. For example, the following query only has one expression.

    For this , you can refer to :
    MSSQLSERVER_8632 - SQL Server | Microsoft Learn

     

    So, for your problem, the only solution is to simplify your dax, or reduce your data size.

    And you can also try to see the query from your sql server profile when you load a visual in your power bi desktop.

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

     

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi ,  Clampazzo 

According to your description, you are using direct query mode in Power BI Desktop.

And when you filter the visual you encounter the error code "Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.".

 

First of all, when we use Direct Query mode to connect to the sql server, then all queries on the visual object, including the measure you write, will be converted into corresponding SQL statements and sent to the data source for query. And this error message is the error message on the SQL SERVER side's limitation:
This issue occurs because SQL Server limits the number of identifiers and constants that can be contained in a single expression of a query. This limit is 65,535. For example, the following query only has one expression.

For this , you can refer to :
MSSQLSERVER_8632 - SQL Server | Microsoft Learn

 

So, for your problem, the only solution is to simplify your dax, or reduce your data size.

And you can also try to see the query from your sql server profile when you load a visual in your power bi desktop.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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