Forum Discussion
Data is missing after Close & Apply
Hello everyone,
I'm trying to understand why Power BI isn't showing the my data after I treated it in Power Query Editor. While on Power Query I see as follow:
| 01/12/2017 04:00:00 | null |
| 01/12/2017 04:05:00 | null |
| 01/12/2017 04:10:00 | -30,27 |
| 01/12/2017 04:15:00 | -30,1 |
After Close & Apply, what I see on Data navigation pane is:
| 01/12/2017 04:00:00 | |
| 01/12/2017 04:05:00 | |
| 01/12/2017 19:30:00 | |
| 01/12/2017 19:35:00 |
It seems that it's not displaying data that is not null, but if I click on the filter it seems to show all values... Can someone explain me why this is happening? Thanks in advance!
4 Replies
Check if these values are "null" or blank. if "null" replace with blank and try
Anonymous
If possible please share a sample pbix file after removing sensitive information.Thanks.
Hi Anonymous ,
You said that when you click "apply and closed", the data column will show blank, right? When you click "apply and closed" button, it will show loading in "report pane", did you see any error information when loading? You need to chcek whether the data type is correct(change this to whole number type or other data type). What is your connect type? import or direct query? You could try to refresh data to see whether it work or not. Or you also could replace null to 0 to see whether it work or not.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
