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 👍
Hello SDittmannFleet
Table visual will only show unique rows, that might be reason for your issue. Can you check which rows are present in power query and not in table visual.
Regards,
Naveen
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.