Data missing from Visuals but visible in Edit Queries

[Thornell]

Hi,

Got a weird one, I've got some data that seems to go missing on my report despite it being visible within the table on the Edit Queries.

I've had to create an appended query for my report as there's too much going on to use multiple tables as it's related to how many events my company has had per day for the last 2 years (work for a broadcast company so we have like 100-200 events a day).

My report shows all the data from 2019, but since I've appended the 2018 data, the 2018 data isn't visible in any of my visuals but is visible in the table when viewing it within Edit Queries.

I've closed and applied multiple times, restarted multiple times and edited my visuals multiple times to see if I could get this data to show, but to no avail.

I've checked all my filters to make sure nothing is affecting it, but from what I can see, no filters are affecting it.

Does anyone have an idea as to why this is happening?

Cheers,

Russell

[btempletn]

I am having an issue with data missing as well. I am using Mongo DB on a local server via DSN and in the Edit Query editor I am able to see the data by filtering by the dates needed. However in my visual it is missing. I am missing data from April to August. 

[v-eachen-msft · Accepted solution]

Hi @Thornell ,

You could check relationships in your model tab. Disable all relationships and check if report is normal.

From your description, could you please check that if you have unchecked the "Enable load":

If it doesn't work, could you please share your pbix file if possible?