Forum Discussion
No data on Published Report but Desktop Report is Working
I had this problem the other day https://community.powerbi.com/t5/Service/Custom-Column-shows-on-Desktop-but-not-on-Service/m-p/257154#M32278
unfortunately the problem is rearing it's ugly head again today. I've removed the dataset and replaced it (that worked until today).
Do you have custom columns created in Power Query in your dataset? I wonder if that is causing some issues...
I do have custom columns, but even using the raw data from the db shows now data, so I don't think it's the custom columns acting up. And unfortunately I have already tried republishing, deleting, and publishing again, or even publishing using a different name. :smileysad:
when you're in Power Query veiwing the raw data the column is empty? I had an issue also where some of the custom columns evaluated to an error - so the issue was with not handling all the exceptions in the code. But I fixed that problem, now the data is showing in the column in Power Query, but not on the visual! :|
my visual on Service stopped showing values - only blanks. I refreshed the dataset from a local copy, the visual was back. I then refreshed the dataset via the Refresh Now link in the service... and we're back to blanks. I wonder if it's something to do with complex custom columns created in Power Query. Are they somehow not compatible with the Service?