Forum Discussion
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...
various options:
- add a step to replace errors
- use try ... otherwise ...
- investigate the cell contents with Value.Is before attempting to expand it.
Hi,
Yeah but we are in a need to import data through sharepoint online. Can you please suggest the changes to be added in m query.