Power BI deleting non-empty rows - can't find fix

[quantfinRguy]

I am importing a file that consists of three columns: [Date], [Label], and [Value]

What is happening is that I have one 0 value in [Value], and that row is getting removed, despite having a [Date] and [Label]. 

The row shows up in Power Query. When I "Close & Apply," the row disappears from the data model. I need it because I am using a COUNTROWS() function to validate time active for each unique [Label] (i.e. do not perform calculation unless [Label] has at least three months of recorded [Value]s)

Does anyone know what is going on? I have not added any steps to remove 0 or blank values/empty rows. 

[v-qiuyu-msft]

Hi @quantfinRguy,

1. In Query Editor, please check which steps listed in Applied Steps pane, please check if the issue related to these steps. 

2. Please click Refresh button in Power BI desktop. 

3. Please run the latest Power BI desktop version.

4. Which kind of file you get data from? Please share a sample source file for us to reproduce the issue. 

Best Regards,
Qiuyun Yu 

[quantfinRguy]

1. The only steps are Source, Navigation, Renamed Columns, and Changed Type. It is not an issue in the steps, as the data somehow does populate if you ADD the step "Filtered Rows," but fails to appear if I include the entire data table.

2. and 3. both have been done previous to posting. 

4. I've managed to recreate the issue using a scrambled data set.

Link to data: https://www.dropbox.com/s/ftvo5q1n6hjhfwj/Data%20Scrambled.csv?dl=0

Link to R script to reshape and import: https://www.dropbox.com/s/x0zho8xgcysnrxq/Data%20Import.R?dl=0

Steps to recreate:

Create new data source using R Script.

Execute `source("YOUR FILEPATH TO 'Data Import.R' HERE")` inside the window.

The specific recurring error is LABEL 124, Date 'March 31, 2015'

If you recreate the error, go back to Power Query and filter the table to just LABEL 124, and it will likely import the row properly.

[Ashish_Mathur]

Hi,

Can you share the download link of your file.

[quantfinRguy]

I created an abridged file but it did not recreate the error.

Interestingly enough, when I used the Power Query row filter to narrow down the table to just the one [Client] label with the error and applied the changes, the 0 row appeared into the data model. If I remove that step and include all the data, the row disappears.