Forum Discussion

edhans's avatar
edhans
Community Champion
7 years ago

Has anyone been able to reliably use Table.ColumnsofType() in Power Query?

I get random success/failures with this function. I have a table called Sales with several columns - number, text, Int64.Type, etc.   The following in a new query returns nothing in the list. No er...
Need Help
edhans's avatar
edhans
Community Champion
7 years ago

I Cherry. No, it isn't resolved. I cannot get it to work reliably as noted above. Sometimes it pulls broad data (like integers, numbers, percents) when i use type number, which is ok I suppose (the documentation isn't clear on this at all), and other times, it pulls nothing.

hansei's avatar
hansei
Helper V
6 years ago

For anyone else who may have hit this page, see this blog for insight. The solutions is to expand type list as such

 

Table.ColumnsOfType(Patients1, {type nullable text})

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Lars Schreiber's investigation, solution and explanation from blog link above worked for me!

    hansei wrote:

    For anyone else who may have hit this page, see this blog for insight. The solutions is to expand type list as such

     

     

    Table.ColumnsOfType(Patients1, {type nullable text})

     

     

    Thanks LarsSchreiber