Forum Discussion
How do I improve render speed?
The table relationships and number of rows are shown in the following image. There are no measures or computed columns. There are lots of summary and aggregate tables - some of them could probably be merged, but that can wait.
Given that everything is pre calculated during the import, I don't yet believe that the issue is related to the schema.
Its quite a small dataset, so i'm really quite surprised you are having performance issues. I was expecting something much much larger. Most of mine load within 5 seconds and are much larger. They probably have half the number of visual elements but are making much more complex run-time calculations. Here is an example of some of mine (a lot of the tables have 500,000 to 1,500,000 records):
What happens if you build a page with the same information you display now, but with simplier visuals? Try to get the same number of visuals, displaying the same information, but using a much simplier visual. Don't be afraid to let them overlap for testing. The purpose here will be to force Power BI to make the same calculations, but test whether the visuals themselves (mainly tachometer and infographic designer) are just slow to draw.