Data different in Power Query than in Data view

[amulder]

Hi,


For some reason my data is changing between Power Query and data view. My source file is a simple Excel table. I import this into Power Query without issue and the data looks exactly the same. However when I view the data in Data view in Power BI the data has changed from a certain record forward. I have deleted the data source and then re-imported, refreshed, cleared the cache and nothing is helping. Why is Power BI doing this????

 

[amulder]

Hi,


For some reason my data is changing between Power Query and data view. My source file is a simple Excel table. I import this into Power Query without issue and the data looks exactly the same. However when I view the data in Data view in Power BI the data has changed from a certain record forward. I have deleted the data source and then re-imported, refreshed, cleared the cache and nothing is helping. Why is Power BI doing this????

[FONT=&quot]I have found the problem was due to rounding of milliseconds in power bi. I updated my source Excel file to round to the nearest 15 minute block and it resolved the issue.[/FONT]