Showing results for 
Search instead for 
Did you mean: 

combine binaries on csv not flowing Type Change to final output


Using the new Combining Binaries functionality is not quite working as expected

In this scenario I'm consolidating CSVs from a folder


While the the Change Type elements are there in the process the final results do not have change type applied




In the Transofrm sample step (view) and Transform Function the type is changed correctly for date and values etc

Type Change 1.PNG


However in the final output it reverts back to MIXED Types

Type Change 2.PNG


Status: New



Thanks for the clear steps. I can repro the same issue as you. I’ve reported it internally to Power BI team: CRI 27259917.

I’ll post here once I get any update for it.


Best Regards,





A fix will be made available in the February 2017 release of PBI Desktop.


Best Regards,



Fantastic, thanks for update

Community Champion

To me it looks like the issue is in fact with Table.ExpandTableColumn as this function doesn't preserve data format.


I already raised an idea to have that adjusted, but may be this would already be the solution in the February 2017 fix?



Super User III
Super User III

Hi @v-haibl-msft 

Has this been fixed? In the latest version of PBI Desktop I still see that Table.ExpandTableColumn does NOT preserve data types

Many thanks