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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Is it possible to have both direct query and imported tables connected to a Azure sql database in a Power BI dataset created in Visual Studio SSDT Tabular project? In Visual Studio there is a property on the Model.bim file -> DirectQuery Mode On/Off but it seem that this will affect the hole project
This is possible when you create the dataset in PowerBI desktop
Anyone?
Hi @Anonymous ,
I am just curious. Are you trying to publish a BIM file created in Visual Studio into Power BI Service? Is this even possible?
thanks,
Sau