Forum Discussion
PBI Pro - Couldn't load the data for this visual
Community ChampionHi RHennings
For a pro licenses the workspace works with a shared capacity, but this wouldn't be the cause if you said that the dataset of the report is not "huge" (to be verified). The cause could be the refresh scheduled time for all reports in the workspace is running at the same time for all. could be also measures or calculated columns in the report that are not optimised. there are many videos on how to optimise DAX measures, Columns and many other things.
I would recomend to start by analysing the Time scheduled.
Hi aj1973 ,
thank you for your answer.
regarding the size. It is 87 MB (Screenshot from the dataset settings in the service)
All the dataset refreshes happen in the morning and all are finished at ~ 6am. The issue existed around 12 -1 pm. No other report in the workspace was affected to that time. Just this report and all the pages of it. Thus I dont think, that it has something to do with the refreshes.
Measures/Calculated columns: We are not using Calculated columns at all & most of the measures do not have complex logic (YTD, MTD, Deviations, etc.). However, there are still a few more complex measures using e.g. iterator functions or switches. In the past, when I used non-optimized measures, the report was just getting really slow. Then I was able to comprehend with e.g. performance analyzer, which measure causes this. But in this case none of the visuals even started loading. As all visuals were affected I had no chance to identify a potentially malicious measure. Therefore the questions for better comprehension.
I am still not sure, if it is an issue of the report/datamodel or if there was a temporary issue in the service, as we have seen this issue only twice. In general this report doesnt have long loading times (1-3 seconds)
Kind regards,
Robert