Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Using Get Data option, I selected a SQL Server and set it to 'Import'. I selected one table in the database for this connection. I connect again to the another SQL Server and want to set it to "Direct Query". It is not being allowed. The "Direct Query" option is greyed out. Is this normal? Wouldn't it be advantageous to have different connection types in the same data model?
Solved! Go to Solution.
@gramchandra The behavior is by design. Either your entire model is Direct Query, or import. There is no mix and match of connection types.
@gramchandra The behavior is by design. Either your entire model is Direct Query, or import. There is no mix and match of connection types.
Thanks for the response. I wish PowerBI allows this feature in the future.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.