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...
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 Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.