Forum Discussion
Responsive ResidentData in Query Editor and Table View but not in Report
Hi,
got a strange one. I have an existing pbix file, which has been working fine for over a year. Now, when doing a data refresh, I see the new data in both, the Query Editor and the Table View in the client.
But the data does not show up in any visuals. See below a comparison between the table view and a table visual:
However, in the same visual on the Web Service, the data is there. And no, there are no filters set on the report/page/visual in the desktop client. I am using the 64 Bit version (November Update).
Anybody with similar issues, or - even better - an idea how to fix this?
Thanks.
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.
11 Replies
skasper,
Please right click your tables in Query Editor, and check if you disable the "Include in report refresh" option. Once the option is disabled, updated data will not appear in report.
Regards,
Lydia- skasper
Thank you Anonymous,
all tables are set to be included in report refresh. I disabled and enabled it again, but to no effect.
skasper，
I am not able to reproduce the issue. The new data don't appear even you click "Refresh" button in report view, right ? If so, how about you open a new PBIX file, re-connect to your data source and re-create the table visual?
Regards,
Lydia
I tried this solution, and it solved my issue. Thanks!
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.I am having the same issue with two columns. They are from a table that is the key table in the project. Second time I've read rebooting PC solved the problem. My PC reboots every night, no reboot fairy. 😞
