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 👍
Hi,
Does the visual table have some summarization on any of the fields? Is it possible to see the data or PBIX file?
I would always use the Power Query data if you aggregating it there, if only for the for performance.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍