Why do some pbix files have a option down by the system tray, "Direct Query: Enabled (click to change)", and other PBIX files are missing that option?
Hi @mbhunt,
Currently we can only change mode from Direct Query to Import, and Import Model cannot be converted back to DirectQuery.
So the "Direct Query: Enabled (click to change)" option will be available only when the data source is connected with Direct Query mode. And you won't see it, if the data source is already connected with Import mode.
Regards
Hi @mbhunt,
Currently we can only change mode from Direct Query to Import, and Import Model cannot be converted back to DirectQuery.
So the "Direct Query: Enabled (click to change)" option will be available only when the data source is connected with Direct Query mode. And you won't see it, if the data source is already connected with Import mode.
Regards
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
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.
