Please enable the inline script feature on Date tables in Fabric Lakehouse Prepare.
I use the feature in SQL to, inter alia, calculate the number of workdays in a month and put those values on each date record for easy reference in various use cases.
The workaround is an auxiliary table with an inline script, but that’s a pain in terms of object dependencies.
