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!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

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
Top Kudoed Authors