Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm experiencing an issue with the stacked area chart in which I get the error message 'The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows.' within PowerBI Desktop. The error is happening as I was testing RLS (Row Level Security) within PowerBI Desktop. That is, I click on 'View as Roles' and enter the 'Other user' called test@test.com (as an example) and select a role I created called 'Tenant'. The 'Tenant' role that was created is using the DAX expression [UserName] = Username().
Now when I 'Stop Viewing' as that user the stacked area chart renders correctly. I'm not too sure what is causing this error and I can only attribute it to RLS. Also, other visualizations are affected by this.
Here is a little more detail about this report:
1. It is using Direct Query.
2. The axis in the stacked area chart is using a date hierarchy that I had to create because it is my understanding that it is not supported by default if a report is using Direct Query.
3. I've submitted a frown on this from my report.
Please let me know if you need anything else from me. Your help is much appreciated
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.