Using Power BI with Enterprise, On-premises Data

I just finished posting a 4-part series demonstrating how to use Power BI with on-premises data.  The running time for all four parts is about 44 minutes.  I cover using the Power BI Enterprise Gateway to connect published Power BI reports to on-premises data sources: 

• SQL Server database connected with DirectQuery
• Large SQL Server database with clustered column store index connected with DirectQuery
• SSAS multidimensional/cube on-prem with direct connect
• SSAS Tabular with large data volume & multiple partitions on-prem with direct connect

The four-part series is on my YouTube channel using the following links:

Part 1

Part 2

Part 3

Part 4

Adam Saxton also gives a nice walkthrough of using SQL Server DirectQuery with Power BI that may provide an additional perspective and information about securing and sharing the solution.

I’d also like to give a plug for a terrific Power BI architecture diagram poster created by Dustin Ryan.  I love the simplicity of this comprehensive graphic.  You can download the PDF file from his blog.