Forum Discussion
Pivot Column in Query
Hi netanel ,
The sample in case seems like not your fact table, right? The error means that PowerQuery is expecting a textual input but receives nothing. You need to make sure it receives a textual input. Try replacing empty fields by "null" or "empty". This can be done either manually within the source (transform the column or create a new column) or within PowerQuery.
About how to replace null values with custom values in PowerQuery:
https://www.edureka.co/community/40467/replace-null-values-custom-values-power-power-query-editor
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi netanel ,
The sample in case seems like not your fact table, right? The error means that PowerQuery is expecting a textual input but receives nothing. You need to make sure it receives a textual input. Try replacing empty fields by "null" or "empty". This can be done either manually within the source (transform the column or create a new column) or within PowerQuery.
About how to replace null values with custom values in PowerQuery:
https://www.edureka.co/community/40467/replace-null-values-custom-values-power-power-query-editor
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.