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

I've changed the parameters in my report to connect to our test environment, and with this connection, all visuals fail to load. This is very strange as our test environment is exactly the same as the production one for this report.