Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm currently using dataflow to agregate multiple table and there no problem there.
However when I load the dataflow into my report some rows that look alike disappear.
I think the calculation optimizer is deleting some rows be cause when I load each table I don't have this loss of data.
I can't desactivate it and I'm not even sure this is the reason.
Is this a known bug, I didn't see much information on internet
Regards,
Antoine
I had cases where some of my data had trailing spaces and others didn't. This can result in the inconsistency you describe as Vertipaq tends to silently trim values. I can demonstrate if desired.
I see the politness is oldfashion, but hello to you too.
Yes I have proof, I'm loading several millions of lines from 6 differents files, I aggregate them in one big table, some lines really look alike but there are no duplicates however I think the enhanced compute engine is deleting some rows or agregating them in the wrong way.
When I load the 6 differents files in the dataflow but aggregate them in Power BI Desktop, the problem disapear.
"I'm currently using dataflow to agregate multiple table and there no problem there"
So you have proof that the Power Query for your dataflow results in all rows being present?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.