Data is missing after Close & Apply

[pedro_desa]

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!

[dax]

Hi @pedro_desa , 

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.

[amitchandak]

Check if these values are  "null" or blank. if "null" replace with blank and try

[pedro_desa]

When in Power Query Editor the values appear as "null" but after Close & Apply they appear as blanks

[amitchandak]

@pedro_desa 

If possible please share a sample pbix file after removing sensitive information.Thanks.