Forum Discussion
Solved
Power Query vs. Aggregating in Power BI: Issue or bug?
So, I am not sure what I'm missing here, but it may just be a difference in how Power Query and Power BI aggregate data. I have a table with the fields "Username", "FirstName", "LastName", "LoginDate...
With hundredths of a second apart it will depend on the format used and you may need to convert it to use it the visual correctly. The solution here might help:
Power Query will work a lot better with this without any additional formatting for a visual so i'd recommend using the aggregation there.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
I can't post any sample output w/o violating privacy. That said, please just trust that Power BI is leaving out records for no discernible reason.