Hello community,
I'm trying to build an SQL view for a BOM explosion, but I'm running into an issue when using a recursive function:
"The query references an object that is not supported in distributed processing mode."
So I'm looking for an alternative approach. Without the ability to use a recursive CTE, I'm running out of ideas.
The goal is to build a Power BI report to analyze component shortages in production.
Has anyone faced the same issue and found a solution?
Thank you for your help,
Emmanuelle G.

Report
All responses (
Answers (