Forum Discussion

gck02's avatar
gck02
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Error fetching data for this visual - Desktop working, service error

Hello,   Recently, a visual displays this error message "Error fetching data for this visual" when visualizing the report in the Service. On Power BI Desktop, everything is working fine.  I've ma...
Need Help
  • gck02's avatar
    gck02
    1 year ago

    I've solved the problem:

    I was using a calculated column to build a date column based on an integer YYYYMMDD column. This column was a filter in a measure and as soon as I switched back to the original integer YYYYMMDD, the visual displayed perfectly.

    What bothers me is that this report was running smoothly for almost 2 years and suddenly the visual was broken without any modification on our side.

    Anyone has an idea about how this calculated column suddenly broke my visual?

    Thanks in advance for your valuable insights. 

gck02's avatar
gck02
Icon for Advocate I rankAdvocate I
1 year ago

Hi Expiscornovus,

For the first step of the tutorial you sent me, everything is fine. An important note, every other visuals on the report are working fine and no changes were made either on the report or the datagateway. 

I've sent the tutorial to the people with access to the admin console and I'll keep you posted about this issue.

Thanks for your help.

Expiscornovus's avatar
Expiscornovus
Icon for Most Valuable Professional rankMost Valuable Professional
1 year ago

Yes, it is a strange one. But they might spot something when they have enabled Additional logging in the gateway. Thanks for keeping us posted on the progress.