Import + DirectQuery in Power BI

ByHariharan Rajendran

Import + DirectQuery in Power BI

Microsoft Power BI team has released a new update called “Composite Models” which is in preview now. This post talks about the composite models.
If there is a requirement to use SQL server and Excel for Power BI report, it was possible only with import mode. It means both the data sources should be used as an import option then we can combine the sources and build the report.
What will happen if I want to use SQL Server as a direct query on the above scenario? We couldn’t combine those two data sources together, but it is possible with this composite model.
How to use?
As this is a preview feature, you need to enable this feature on “Preview Features” section.
Once enabled then you can add SQL Server Direct Query and Excel together within Power BI desktop and start building the reports.
Considerations
1. When you decide to go with this feature, you need to ensure to accept the below message. The information of the one data source might have sent to other data source while fetching the data from different sources.

Still, there are few limitations with this composite model.
This composite model consists of below features which we will discuss in our next post.
1. Many-to-Many relationships
2. Storage Mode

About the Author

Hariharan Rajendran author

Hariharan Rajendran is a Microsoft Certified Trainer and Lead BI Solutions Consultant with 8+ years of experience in Database, BI and Azure platforms. Hariharan is also an active community leader, speaker & organizer and leads the Microsoft PUG (Power BI User Group – Chennai), SQLPASS Power BI Local Group – Chennai and an active speaker in SQL Server Chennai User Group and also a leader in Data Awareness Program worldwide events. Hariharan also frequently blogs (www.dataap.org/blog), provides virtual training (on ad-hoc basis) on Microsoft Azure, Database Administration, Power BI and database development to worldwide clients/audience.

Comments Are Closed!!!