Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

 

E.g. 

 

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
Comments
v-haibl-msft
Employee

@wynhopkins

 

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,

Herbert

v-haibl-msft
Employee

@wynhopkins

 

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

 

Best Regards,

Herbert

wynhopkins
MVP

Fantastic, thanks for update

MarcelBeug
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?

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17678083-preserve-data-types-when...

 

 

AlB
Super User
Super User

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