cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
k3rz0rg Member
Member

Issue with the date column!

Hi all,

 

lately I am experiencing an issue with the date column in one of my reports!

When I load the data from the query editor refresh with excel as source keeping historical data, the table shows that it has the most recent date inside the query editor. Then I do the close and apply but at the data view section of the desktop, the column does not show the most recent months. It is stuck until june. I have no filter set on that table or anywhere!

Can somebody heap me with that?

 

UMR Query Editor.jpg                  UMR Data View.jpg

 

 

 

 

 

 

 

 

 

 

 

 

The left one is inside the query editor which seems fine but the right one is the data view, even after so many refresh, its still the same.

 

Any help would be appreciated.

 

Thanks,

K3.

1 ACCEPTED SOLUTION

Accepted Solutions
k3rz0rg Member
Member

Re: Issue with the date column!

Thank you all for the suggestions, however, nothing helped to solve that weird issue.

I ended up recreating the exact same report with exact same data copying the exact same code from the adavanced editor for each table and the new report has no issue! 

I still don't understand what happened with the older report that was not showing me any data beyond june but the 100% replica is working fine!

 

Anyways, thank you all for responding to my issue and the suggestions.

 

- K3

View solution in original post

9 REPLIES 9
MCornish Member
Member

Re: Issue with the date column!

Have you got a step that filters them later, or on your report, a slicer/report level filter?

Re: Issue with the date column!

Looks like a modelling outside the query editor, the format on the modelling pane, but had to look for the exact cause.

k3rz0rg Member
Member

Re: Issue with the date column!

Hi @MCornish , I have no filter on any of the tables, it's just taking the data from query editor straight! I do have date slicer but also tried removing those slicer but no luck.

 

Hi @DuarteRaminhosB , I checked the modeling pan and tab, removing/modifying all the connections, tweaking them in multiple ways yet no luck. 

Re: Issue with the date column!

I just saw thats the table pane, are the visualizations wrong when you put it in any visual?

k3rz0rg Member
Member

Re: Issue with the date column!

@DuarteRaminhosB , I tried removing all the visuals but the tables and looked at the table data, the data remains same like I posted, until june, don't know what's causing this issue. Recreating this entire report from the scratch would be pain in the rear!

Re: Issue with the date column!

 

delete.pngChanging this format section is the only solution I can remember of but can only know better by watching the file.

k3rz0rg Member
Member

Re: Issue with the date column!

@DuarteRaminhosB , I don't think formatting is the issue. I've done that as well. It seems like the table in the data view is not updating after refresh or after the close & apply from the query editor! I am maintaining historical data in the table called permsource which takes data with the sync table that gets refreshed; everything was working fine until June then this! Data gets refreshed accordingly, query editor looks good, source is perfectly alright, no change in the report but can't get a clue why is this happening.

Even published one is the same, even after the online refresh!

Re: Issue with the date column!

The only situation I had that seemed like it was the regional settings which can affect the dates format, othe rthan that can't remember any other solution. If you identify any other kind of problem/solution please let me know. Meanwhile if I encounter a similar problem I'll reach you.

k3rz0rg Member
Member

Re: Issue with the date column!

Thank you all for the suggestions, however, nothing helped to solve that weird issue.

I ended up recreating the exact same report with exact same data copying the exact same code from the adavanced editor for each table and the new report has no issue! 

I still don't understand what happened with the older report that was not showing me any data beyond june but the 100% replica is working fine!

 

Anyways, thank you all for responding to my issue and the suggestions.

 

- K3

View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors