Forum Discussion
Modeling for SCD2 type fact table
I'm familiar with these articles, and I have a DAX measure to get me where I need. The problem is it's on a fact table (not a Dimension) so the table is huge (millions of records). When I try to drill through on a given summary, it tanks. Even in desktop I get the "exceeds available resources" and that's using filters down to a very small recordset.
Hi Anonymous ,
This issue occurs when a visual has attempted to query too much data with the available resources. As a workaround, you can try filtering the visual to reduce the amount of data in the result. And try removing details fields display on visuals. If you need that certain detail, consider reducing and adding a drill through chart to give you more information. Hope the following documentation can help you.
https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/
Best Regards
Rena
Thank you Anonymous
As I stated in my previous post, I'm already filtering to just a few records. I've actually tried filtering to just a single record and it fails. I'm not using many details at all. The only difference is that it's not summarized when you drill through but it's using the measure to control filtering.
I'm thinking there is a better way to model it, but I cant think of how.