The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a strange behaviour after expanding a merged query.
I've created a table (EUCHISTORY) giving the following results
So far all is working as required
Now i've merged this table with the table EUCDECLARATION based on DECLARATIONGUID
Still is still the expected result.
But, when i expand the table, i receive following result.
This is not the expected result.
Current Result = DMSACC/DMSCLE/DMSTAX
Expected Result = DMSACC/DMSTAX/DMSCLE
This is driving my crazy.
Someone any solution or sugestion.
Much appreciated.
Steve
Power Query does not give any sorting guarantees. If your expected order differs from an alphabetic order then you need to bring your own index column.