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

[Clampazzo]

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

When I create a visual with Date, Hour, and a measure (Number of Open Cases) the visual works.  

However, if I use the filters on the right to try and filter on the values (IE:  where open cases is greater than 0).  I get the following error.

Can someone tell me what this is and how to fix it?

[v-yueyunzh-msft · Accepted solution]

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