Forum Discussion
Data in Query Editor and Table View but not in Report
Update: without changing anything in the original pbix, it is working today. The ONLY thing that's different from yesterday on my side is that I rebooted my PC. I don't see, how this would make a difference, though.
I will mark this as solved just to close the thread. Thank you for your efforts.
Looks like I'm years late to this party - but I was just experiencing the issue, in my case, specifically Date fields.
I was losing my mind. In Query Editor, and in Table View on the Desktop .pbix file - the dates were showing. In the .pbix file, I set the date type fields to dates in MM/DD/YYYY format, joined them to a custom calendar table I created, but when I used the custom calendar date slicer, the data from the table joining by date returned nothing.
I put a Card in the visual and brought the date field down and the value showed as (Blank).
I went into Query Editor, selected the Date column and the Data Type showed as "Any". I flipped this to Date, refreshed the dataset and the dates were now presented and working with the joined date via the slicer, returning the data/performing the custom measures that I needed.
I struggled with this for a couple of days - and of course, like most everything else we do, the solution was simpler than I had thought. I cannot guarantee this will work for your issues as well, but I'd recommend heading over to Query Editor and checking the Data Type. If you see "Any" - chances are, you have to change that.