cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jcs93 Frequent Visitor
Frequent Visitor

Visual Not loading - RLS and Direct Query

I have an issue in a report I'm developing...Here's the summary

 

Large report, using a mix of Direct Query and Import to compartmentalize data to allow deployment with RLS, restricting table access on a use case-by-use case basis.

 

Works greate on the desktop and online, until I include Conditional Formatting in a visual that's pulling data from a DQ Table.  When I "view as role," I get an error code of "Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.. The exception was raised by the IDbCommand interface."

 

When I 'copy details' and look at the code, it ends up being about ~19,000 characters.  I've since turned many of my queries into SQL views to reduce the line/character count, thus simplifying the m code behind.

 

In short, a large report (~146mb PBIX) with 22 tables with a mix of Import and Direct Query.  The 'M Query' to build is 13,352 characters after changing over to 5 SQL Views.  I'm using the April 2019 version of PBI Desktop.  The 'Failure to load visual' only comes up on a single visual that pulls data from a single table.

 

I do have one other visual that uses DQ through a SQL View with Conditional Formatting that works just fine.

1 ACCEPTED SOLUTION

Accepted Solutions
jcs93 Frequent Visitor
Frequent Visitor

Re: Visual Not loading - RLS and Direct Query

@v-xicai 

 

Thank you...you got me pointed in the right direction.  It turned out that my custom columns in the DQ table were the culprit.  I remove the custom columns and put the fields into SQL and it works perfectly.

2 REPLIES 2
v-xicai New Contributor
New Contributor

Re: Visual Not loading - RLS and Direct Query

Hi @jcs93 ,

 

According to your error messageSmiley Embarassed>"Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.. The exception was raised by the IDbCommand interface.". Maybe you have create a column or measure using complex DAX code, please simplify it, for and try it again.

Or try to upgrade the Power BI Desktop to the latest version 2.68.5432.841.

 

If the issue still exist ,I would suggest you create a support ticket  to get dedicated support: 

 

1.gif

Best Regards,

Amy

 

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

 

jcs93 Frequent Visitor
Frequent Visitor

Re: Visual Not loading - RLS and Direct Query

@v-xicai 

 

Thank you...you got me pointed in the right direction.  It turned out that my custom columns in the DQ table were the culprit.  I remove the custom columns and put the fields into SQL and it works perfectly.