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
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi edhans,

 

Have you solved your problem?

 

If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please feel free to ask.

 

Best  Regards,

Cherry

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