Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I have recently enabled this option on one of my direct query reports to see if it helps the speed of it but it doesnt seem to be doing anything - it has had 2 refreshes so far both of which have results in 0mb of aggregations being created and the error message:
No SystemManaged table found after PA Training
Can't seem to find anything about this - anybody able to help?
There is some very detailed documentation here:
https://docs.microsoft.com/en-us/power-bi/enterprise/aggregations-auto
One issue you may be running into, is the very limited set of sources that are currently supported...
I hadn't read this when I turned it on for one of my datasets. I was getting...
I already had aggs setup and working so I turned auto aggs off. Will revisit when more sources are supported.
Hope this helps.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
I've been through that page a few times trying to find an answer - unfortunately to no avail.
All of my sources are Snowflake other than:
As a test, you could try and setup a couple of new reports, pointing at the dataset that you have turned on auto aggs for. Have the new reports each at a different grain to see if that triggers anything to recalculate.
Other than that, I'm not really sure.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |