cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Power BI error that is replacing dates from query view to data view

I have imported data into power bi from excel. Everything appears fine in the query view, but when I go into the data view, the dates have literally changed. Instead of being a random assortment of dates that are associated with each row, each row now has the exact same date. I have no idea how this is happening. All I have done is apply changes and the date is showing up different.

 

This is the query view:

query.png

 

This is the data view:

data view.png

 

Can someone please help?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User VI
Super User VI

Re: Power BI error that is replacing dates from query view to data view

@KiFa 

Power Query is only preview of data. So, first option is to make sure you have no such rows in your data source


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

2 REPLIES 2
Highlighted
Super User VI
Super User VI

Re: Power BI error that is replacing dates from query view to data view

@KiFa 

Power Query is only preview of data. So, first option is to make sure you have no such rows in your data source


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Highlighted
Frequent Visitor

Re: Power BI error that is replacing dates from query view to data view

You gave me an idea. It was the sorting.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors