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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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 Solution Authors