Getting Data Into Power BI

Target Audience:

Business Analyst, Developers & DBAs using Power BI.


Power BI is such a powerful tool to develop visualizations. In order to display visuals, the developers of Power BI reports need to understand how data is organized in a data model. The sources vary. So examples of spreadsheets, flat tables or files and relational database tables all have a place in a data model.

The spreadsheet example is great for using the Mashup techniques in Power Query (M Code). The flat table or file can help speed up the development of the report. The relation table involves database design skills which new data modelers usually do not have at the needed level. Most think they do have it because of T-SQL skills developed over their career.

This session will flow from one example to another and demonstrate the best path for a developer of Power BI reports. Power BI users will understand the uses of a relational database to develop in a enterprise or corporate environment. The path will help the attendee have an 'ah ha' moment about data models in Power BI.

Why I Want to Present This Session:

I see to many people start using Power BI without understanding the complications of not getting the data modeling correct. Then, many Power BI reports are developed and released with proper modeling. Then, they say, yes I can do it this way, see!!! Too many times they loss sight of the big picture.

Additional Resources:

The following two tabs change content below.

Thomas LeBlanc

Latest posts by Thomas LeBlanc (see all)

Previous Post
Getting Started with Azure Data Factory
Next Post
SQL Server Developer Tricks

1 Comment. Leave new

M A Srinivas
March 7, 2019 9:47 am

Waiting for this


Leave a Reply to M A Srinivas Cancel reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.