Loading Files With Varying Schema in Power BI using Power Query
Unpivoting in PowerQuery is easy, but what if you don’t know how many columns you have to unpivot?
Unpivoting in PowerQuery is easy, but what if you don’t know how many columns you have to unpivot?
Power Query shenanigans, but does it fold?