Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Couldn't load data for this visual

One visual in the PowerBI service does not render correctly and the following error is displayed: Couldn't load the data for this visual Couldn't retrieve the data for this visual. Please try again...
Need Help
Anand24's avatar
Anand24
Super User
5 years ago

Hi Anonymous ,

 

This is a very common error faced in Services when DirectQuery is used. This mainly occurs because Services takes time to get data and if the time exceeds a particular threshold, it throws the error. This threshold erstriction is not present in Desktop and hence you won't see the error there.

What you can do is use Performance analyzer in Power BI Desktop and try to optimize your DAX as much as possible. DAX+DirectQuery takes a lot of time to render the visual.

 

If nothing works from your end, you can raise a ticket with MS Support.

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks Anand24 

     

    I thought it might to do with timeout thresholds, but I cannot figure out why this is happening.

     

    Do you know of a way in which I can optimize the query in the original post? From what I can see is that ALLEXCEPT is taking a longtime to process.