Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
mroberts_troy
Advocate II
Advocate II

Error saving Dataflow - One or more tables references a dynamic datasource

So I've seen lots of threads about this, but my case is different (I think).  I have built a standard dataflow that will be deployed to every project workspace.  Unfortunately, not every project has one of the key datasources, so I have built in a final step in each query that simply says "try #"The Last Step" otherwise #table({}, {})".  This is my way of preventing failures in case that "required" datasource isn't available.

 

That's the only thing I've changed on this dataflow template.

 

But now I can't get the edited dataflow to save - it says "One or more tables references a dynamic datasource".  

 

Does anyone have any recommendations?

1 REPLY 1
mroberts_troy
Advocate II
Advocate II

Due to needing this done ASAP, I decided to create a template without any references to the missing file.  If someone could still make a recommendation so we can consolidate these templates, that would be super.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors