Forum Discussion
Solved
PowerBI desktop - using different connection methods to database in the same pbix file
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?
gramchandra The behavior is by design. Either your entire model is Direct Query, or import. There is no mix and match of connection types.
2 Replies
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.
