Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi All,
This is a strange one, We have been using the "Change Data Source" feature for our financial system reports, to swap between development and production servers.
We connect to a SQL SERVER data source, using windows credentials.
We run Direct Query mode.
After flicking back and forth, several times, and admittedly playing a bit with credentials and all the various settings, our projects locked themselves into a "Import Data" state, that could not be reversed. Direct query was completely disabled. I could not find any setting that seemed to re enable direct query.
In the end I simply started over, recreating the project and report and everything works well again. But I'd like to know whats happening that could have lead to this scenario, as we do need a method for swapping between servers without keeping "DEV" and "PROD" versions of a report.... effectively doing the work twice.
Thanks,
Solved! Go to Solution.
@andrmh Are you inadvertantly connecting to multiple databases? DQ only works against one database. It should be fine if it's the same db in both environments and you are just swapping connections...
@andrmh Are you inadvertantly connecting to multiple databases? DQ only works against one database. It should be fine if it's the same db in both environments and you are just swapping connections...
This is most likely it.
Thank you.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!