Forum Discussion

NithyaKB's avatar
NithyaKB
Helper I
4 years ago
Solved

Power Query - Replacing empty cells in source with null in M query

Hi, I have a table in which say for example in  a table column title  has empty values for few rows .I am expanding my table in Power query and fetching only the title column.For few rows it is show...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    various options:

     

    - add a step to replace errors

    - use try ... otherwise ...     

    - investigate the cell contents with Value.Is  before attempting to expand it.