Forum Discussion
Error fetching data for this visual - Desktop working, service error
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.
Hi gck02,
If it works on Power BI Desktop but not on the Service my first suggested step would be to inspect the Gateway logs. Below are a couple of examples on how to troubleshoot the gateway:
Did you see any error in there related to that issue?
And did you check your SQL Server logs? Maybe that also gives you some clues on what is happening.
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.
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.