Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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?
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.