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. 

APQueiroz's avatar
APQueiroz
Frequent Visitor
1 year ago

Hello gck02,

 

I encountered a similar issue recently. I was using an on-premises gateway with ODBC to connect to an on-premises database, but I kept getting an error message and couldn't resolve it despite numerous attempts. As a partial solution, I switched to using a personal gateway, which allowed the dataset to update without any problems. Have you tried this method?

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

    Hi APQueiroz 

    Unfortunately, using a personal gateway is not possible with our work environment.

    Thanks for your answer.