Visual not rendering in the service

[PaulDBrown]

Good afternoon,

Is anyone having a problem with some types of visuals not rendering in the service?

I have one scatter chart visual in particular (default PBI; not custom) with problems (since Friday more or less). I'm getting a message stating "Cannot load the data for this visual". (I have tried both on Edge and Chrome, not that I think that has anything to do with loading the data...).

It was working fine a week ago and the visual renders beautifully in Desktop. 

(Another scatter chart however renders without a hitch, so it's something affecting this one in particular)

Any ideas on how to troubleshoot it?

Thanks!

[v-yingjl]

Hi @PaulDBrown ,

I have tested it both in Edge and Chrome in my environment to try to reproduce it but both of them seem work fine. One reason that could cause this issue may be the browser cache. Perhaps you can try to clear the browser cache to try it again. 

If not help, you can share some screenshots and show the details of the error message for further discussion.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

@v-yingjl 

Hi! Thanks for looking into this.

I just tried clearing the cache, but no luck.

Here are the screenshots:

Visual (bottom in page) as seen in Desktop

Same page as seen in PBI service:

Thanks again,

Best

Paul.

PS. not sure if this is helpful, but there are no gateways being used. I update the data manually in Desktop and then publish the file. As I say, this started occurring late last week. It was rendering fine before then (for weeks)

[v-yingjl]

Hi @PaulDBrown ,

Based on my research, one reason that could cause this issue is that the data point limit in scatter chart. As your mentioned previously, you refresh data in power bi desktop manually, your dataset maybe too large while the data point limit in scatter chart is 3500 if you have not enabled 'High-Density Sampling' in it. If so, you can try to enable this option and try it again.

Please refer this document about it: High density sampling in Power BI scatter charts 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

@v-yingjl 

Thanks again for the suggestion. I checked and the "High Density Sampling" setting is on (it is by default I believe).

I don't think the sampling can be causing the problem, since the values are by country, and I have about 200 in the dataset.

I'm really baffled. I might have to resort to deleting the visual and re-doing it, which is a real pain since there are bookmarks associated to it. It doesn't really make much sense since it works fine in Desktop. It just breaks when published.

I'm going to try saving the report as a new file and publish that. See if that auto-magically solves it...

Any other ideas before I re-do the whole thing?

[PaulDBrown · Accepted solution]

@v-yingjl 

Solved it. I saved the file with another name, published it and the visual renders fine...Something breaks in the service (I guess) when I publish the original file. 

Thanks for your time and suggestions!

Best Paul.