Forum Discussion
Blank Data in Published Report
Anonymous - Many times when this occurs, resetting the report back to default in the Service solves the problem. Sorry if this was a suggestion from another post but you didn't list what you had tried thus far.
Anonymous - Many times when this occurs, resetting the report back to default in the Service solves the problem. Sorry if this was a suggestion from another post but you didn't list what you had tried thus far.
Hi,
I'm having the same issue. I replied to a different comment earlier but it's still happening.
90% of the time, my "Today's Sales" page will be completely blank. I've checked my filters and the only filter there is has a "today's sale" indicator. It's a very simple line of Dax: today_ind = if(sale_date = today(), 1, 0), and the ind has to be 1 on the page. Sometimes the page does populate. There aren't any dropdowns on the page, so there isn't a button to "Reset to Default". It works on the desktop version, always, but not on the online service. It also doesn't work if I filter by relevant date being 0 and including today.
Is this possibly because the online service is based on UTC instead of the local time that's published from? I really can't think of anything else. I have a different page for "This Week's Sales" and the sales show for today's date.
Any help would be greatly appreciated!
What worked for me was going to the filter section of the published report and changing True/False values to 0/-1 values. For some reason, the web version recognized T/F values in this format, but the formatting of the filter is not converted during publishing.
