Forum Discussion
No data on Published Report but Desktop Report is Working
May be related to http://community.powerbi.com/t5/Service/Online-Published-Report-is-Not-Refreshing/m-p/190481#M25861 but republishing didn't work for me.
I have a PBI Report that was previously published and connects to Azure SQL db. Recently an outage caused the db to stop updating, the db has since been fixed. However, while the report on PBI Desktop is working, the one on published page does not work, shows no data at all. Even if I delete the current published report and republish, the charts are still empty.
7 Replies
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! :|
