Visuals not updating after refresh, data drops off and most recent data is completely missing

[guh950]

I have a weird issue with a page of one of my tabs in PBI. The document shows historical data up until the beginning of August, then suddenly drops off after a day or two into August. The last few months are not visualizing for me. However, the rest of the data on the visual is coming through. I looked through the data tab, and the data exists. The rest of the tabs are showing the newest data just fine, but I double checked filter settings for that page, and there's nothing. The visuals don't have special filtering to exclude out more recent dates, so I'm not sure what's going on:

Here's my filtering setting showing that I'm not filtering it out, it just doesn't show up:

Here's the PBI data tab showing the data is populated in PBI, but not getting to the visual

The above chart looks just fine, until August and then a vast majority of the data disappears. September doesn't even show up.

Here's what I've looked at:

Page filters are not conflicting

Report filters are not conflicting

The data is coming through just fine until August and then stops

[rifij]

I had a similar issue that occurred this month where data sets refreshed but visuals werent. After various troubleshooting, realized i hid/turned off a date slicer which was preventing visuals from updating. After turning it back on, visuals rendered like usual.

[v-chenwuz-msft]

Hi @guh950 ,

i recommend that you should check your measure which calculate the rate. transform the line chart to table and find the date without data. Maybe use DIVIDE() instead of /. 

Or provide some example data in the pbix file and i can help you to check it.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[guh950 · Accepted solution]

Hi @v-chenwuz-msft ,

I found out that the exact file in question had a memory error associated with too many rows trying to be queried at the same time. I reduced that query and split it up, thus getting around a whole month of missing data. I also got my September and October data to pull through, which was a relief.

[ebdsmia]

Hi @guh950! I am encountering the same exact problem. Can you expand a little on how you solved your issue? Much appreciated!

[guh950]

Hi @mwegener Date table exists, and all values are populated in the date table:

The data model (for this particular fact table) is the following:

Dimension - MonthLookup (datetable) --> Fact Table

Dimension - RegionLookupTable --> Fact Table

Dimension - RetailerLookupTable --> Fact Table

Dimension - ProductNameConsolidatedTable -->  Fact Table

[mwegener]

Hi @guh950 

strange that September is not displayed in the filter selection.

Were birectional filters used?

Can you share a screenshot of the data model view?

[guh950]

@mwegener For this fact table, it was one to many for all relationships. I can send the full data model screencap but it might make the situation more confusing to understand, and might not be helpful due to the directionality of the relationships.

[mwegener]

Hi @guh950 ,

i don't know. I would have to check the whole file.

[mwegener]

Hi @guh950 ,

can you give a little insight into the data model?
Do you use a date table?
Are all date values available in the date table?