Invoke custom function: returned table neglects column data formats

[Anonymous]

Hi,

I use a custom function to transform multiple excel workbooks and worksheets. Therefore, I pass two parameters, the path to the workbook and the name of the worksheet. When I manually test the custom function the created result table considers the column data types. However, when I invoke the custom function from my query the column format of my returned table is only text.

I noticed in the video below at the very end after minute 23 that the returned  table apparently also does not returned the column types defined within the function.

https://www.youtube.com/watch?v=rohXtAlIgqY

Any advise highly appreciated.

Thanks and best regards

Thomas

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Set-column-type-while-expanding-from-merged-query/m-p/307648#M136144