Forum Discussion
Error message when refreshing data due to Null Value
Hi, MarcusPH
1. From the PQ editor disable loading this query. If this table is not merged or connected with any other table/visual, it won't affect much. Later on you can check the tables data and filter out the nulls. To disable loading a query right click on it and uncheck enable load ...
2. Like I mentioned, if you see any column with a blank value you can filter it out in PQ. To filter out specific values from PQ editor, click on the drop-down of that specific column and uncheck your desired values. It will filter out the values you selected.
Also, you can check column distribution to check if you have got null or errors, distinct unique every detail of your query. From view>> check column distribution.
Hi, MarcusPH
1. From the PQ editor disable loading this query. If this table is not merged or connected with any other table/visual, it won't affect much. Later on you can check the tables data and filter out the nulls. To disable loading a query right click on it and uncheck enable load ...
2. Like I mentioned, if you see any column with a blank value you can filter it out in PQ. To filter out specific values from PQ editor, click on the drop-down of that specific column and uncheck your desired values. It will filter out the values you selected.
Also, you can check column distribution to check if you have got null or errors, distinct unique every detail of your query. From view>> check column distribution.
Thank you for your response. Using the PQ editor worked, just what I was looking for.
Marcus
