Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How do i start troubleshooting my power bi report.
My environment:
Designing reports after importing data into Power BI from SQL Server.
We want report to be displayed as early as possible.
Thanks....
Solved! Go to Solution.
Few things we need to consider here,
1) Try to take the required data only from your source
2) Check "Enable load" option in Query editor ( disable this option if not required)
3) Minimize the usage of external graphs(downloaded from market place)
4) Split date & time into 2 columns
5) Always import SQL views insted of tables into PBI data model
6) Apply mark as date table to date column in calendar table( if created).
Few things we need to consider here,
1) Try to take the required data only from your source
2) Check "Enable load" option in Query editor ( disable this option if not required)
3) Minimize the usage of external graphs(downloaded from market place)
4) Split date & time into 2 columns
5) Always import SQL views insted of tables into PBI data model
6) Apply mark as date table to date column in calendar table( if created).
Thanks for your comment
can you please expalin 3rd and 5th points?
once we load the custom visual from marketplace into the report, what is the difference from the normal visual?
what is the perfromance problem if we have both date and time in single column?
Thanks..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |