Forum Discussion
Embedded report with semantic model data source doesn't load
So it looks like what happened is I had configured my RLS in a way that Power BI didn't like. I had 12 dimension and fact tables that needed RLS applied, and the way I was doing it initially was to duplicate my `identity` and `tenant` tables so that each table had their own set of RLS tables. This worked fine in Power BI Desktop and the Power BI Service, but once it got to the embedded environment it was unable to process all of the tables/relationships. I was able to do the RLS in a different way that was less resource intensive in the embedded environment.
Hi edyck ,
Base on your description, it got the resouces exceeded error when embed the report for customer with RLS. However, the report can load normally in Power BI Service. It seems like the report is OK. Could you please check if hit any following limitation to cause the error:
Considerations and limitations
In addition, please review the following links about the resources exceeded error. Hope they can help you solve the problem.
Chris Webb's BI Blog: The “Visual Has Exceeded The Available Resources” Error In Power BI
Solved: Service: Visual has exceeded available resources. ... - Microsoft Fabric Community
Best Regards
Hi Anonymous,
When generating the token I am providing a valid role and username, so I don't think it's that. Also, typically if the issue is a role not being specified an error is thrown when generating the token, not when displaying the report.
I checked out the links you provided, but both of them assume that there is bad DAX or large datasets that are causing resource exhaustion, which shouldn't be the problem in my case because the dataset doesn't have much DAX and the entire data model is only around 12 MiB.