Best practice - Sql server Source

[JyothsnaTpally]

Hello everyone- what is the best practice to pull the required data into the Power BI desktop - tables, views or stored procedures.?

Please let me know the best scenarios for each.

I read a lot of resources, it is confusing when to use what.

Any advice is appreciated!

Thanks,

JT

[pallavi_r · Accepted solution]

Hi @JyothsnaTpally 

These are couple of important points to be followed.

1. Better to do all the aggregations in sql server before loading the data in the power bi

2. Power query can do all sort of transformations, but its best to do all data manipulations at sql end.

3. Create a view instead of pulling data directly from tables. This will avoid any changes on pbix (joins, aggregations, range, where clause etc) once deployed.

4. Parametrize the server name, database name and schema name to avoid multiple time changes

Thanks,

Pallavi