Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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
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