Forum Discussion
Crossfilter function in Fabric semantic model measure issue?
I am using a measure, that is having crossfilter function in it and the filterdirection is set as None. This measure runs without any issue when I use SSAS model and we are using this measure since very long, but when I connect with Semantic model from Fabric, it
throws an error as:
While searching for the error, it gives results as there is an issue with RLS and fabric does not allows the use of crossfilter or userelationship function because it exposes data which does not follow RLS. Just for testing purpose, I have deployed the model without RLS, but still it gives me the same error, seems like the problem is not because of the RLS.
The semantic model has been deployed using updated tabular editor directly in the fabric workspace having PPU capacity.
Does anybody has any idea, where the problem is?
Thanks in advance.
You would have to check the query plan to validate that assumption.
9 Replies
Does the crossfilter result in more than 1M rows?
Hallo Ibendlin, yes the crossfilter results more than 1M rows.
That will hit the limit set in the Capacity management section. It is not recommended to increase that limit, it is there for a reason.
Hi vvishwakarma
As it was known issue addressed recently you can refer the below link and follow the steps to resolve your issue.Reference link : https://learn.microsoft.com/en-us/fabric/known-issues/known-issue-1002-reports-functions-rls-not-work
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.I also have outer filters, which i believe limits the crossfilter to scan less number of rows. I am not an expert in query plans of vertipaq engine, but I hope the outer filter has an effect on the number of rows from the crossfilter function and then it would be far less then 1M rows in context.
You would have to check the query plan to validate that assumption.
Hi vvishwakarma
I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!
Best Regards,
Cheri Srikanth.Hi vvishwakarma
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!
Best Regards,
Cheri Srikanth.Hi vvishwakarma
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.
