web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

SQL view for Bill of Materials (BOM) explosion

(0) ShareShare
ReportReport
Posted on by 70

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.

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 103 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 100

#3
Subra Profile Picture

Subra 91

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans