Get data: SQL Views

[NicolasVanGent]

Hello everyone, 

I took several power BI-trainings and did extensive research about data modelling. But now, I am starting my first BI-project and I am doubting about the "get data" fundamentals. I will try to formulate my question as short as possible.

Situation:

Data source: SQL DB

Tables: + 100

> 10.000.000 rows in multiple tables (with relationships)

I want to create a dataset which I can use to build several reports, my basis assumption is to work as close to the source as possible. The dataset should contain the information I need for the nex couple of months/years.

Question: I am planning to build multiple views and create my dimension tables and facttables in the SQL DB, this way I can import the right information directly in PBI. Is this the right way to get started? extra: I would make my relationships in PBI?

This is based on: https://data-mozart.com/3-reasons-to-use-views-instead-of-tables-in-power-bi/

The practical side of "get data" end data modelling is quite new to me, so if you guys have any good sources/documentation, I am open to suggestions.

Thanks.

Kind regards.

[gauthamboppana · Accepted solution]

@NicolasVanGent  - Your approach is fine. Create your dimensions and fact tables / views in SQL and import them into Power BI. And, then do the modelling. 

Alternatively, you can look into Data Flows or Data Marts in Power BI service.  Using Data Flows, you can set up some Master tables  and then use these tables to create Power BI datasets and reports.

Please refer to the below sources.

https://docs.microsoft.com/en-us/power-bi/guidance/whitepaper-powerbi-enterprise-deployment
https://www.youtube.com/watch?v=islhUWaCiJ0
https://www.youtube.com/watch?v=7ciFtfi-kQs

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !

[NicolasVanGent]

Thank you very much. 

I will definitely look in to data marts and data flows.

Kind regards.