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.
In PowerQuery I often use a combination of "Table.GroupBy" with "All rows" aggregation then "Table.AddColumn(,, Table.AddIndexColumn()" to create indexes within groups and then expand the latest grouped column. I took this idea from this website:
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query
But when I create the second grouped column that will contain this index, all the columns in this table lose their data types.
The website says so as well.
Is there a way to make it persistent?
I mean, it is creating an object from an existing one. Shouldn't it be automatic to keep the datatypes instead of trying to infer data types each time?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @FireFighter1017
By default, new column defind don't have a data type. You need changed the data type after creating column in Power Query.
Best Regards,
Community Support Team _Caiyun Zheng