Forum Discussion
Error message when refreshing data due to Null Value
Hi there,
I download a lot of data into power bi at the end of each month. I have been doing this for over a year and with the exception of a few "this computer has placed the database in an Admin state" issues that seem to resolve when I open and close the program I haven't really had any issues. This month however I am getting the following error message:
The PaxSectorALLTX table takes values from another table in the program and doesn't really recieve data directly from the Azure Database. The tables that do accept data from the Azure database all seem to revieve the data even though there is an apparaent cell with a null in it.
Is it possible to stop this particular table from updating during the refresh sequence so I can get the data into power bi and then try and search for the null? Once it is corrected then update the offending table?
Otherwise is it possible to have the program ignore null values when downloading the data into power bi?
I hope this is enough information, I am certainly not an expert at power bi but I need to get this issue resolved.
Thank you in advance,
Marcus
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.
2 Replies
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
