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 "Dire...
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.