Missing data after closing the Query Editor

[rylach]

I have a simple database-based query:

let
Source = Sql.Database("my.sqlserver", "mydb", [CreateNavigationProperties=false, CommandTimeout=#duration(0, 0, 1, 0), HierarchicalNavigation=true]),
dbo = Source{[Schema="dbo"]}[Data],
reports_v1 = dbo{[Name="reports_v"]}[Data],
#"Removed Columns" = Table.RemoveColumns(reports_v1,{"timeworked_minutes", "id", "evid", "customername"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [created] >= #datetime(2016, 1, 1, 0, 0, 0) and [created] <= #datetime(2017, 12, 31, 0, 0, 0)),
#"Extracted Date" = Table.TransformColumns(#"Filtered Rows",{{"created", DateTime.Date}}),
#"Removed Columns1" = Table.RemoveColumns(#"Extracted Date",{ HERE SOME TABLES TO REMOVE})
in
#"Removed Columns1"

The problem is, that Preview display in Query Editor does have the data (also while highliting the last step), but when I click 'Close and apply' the resulting table in Power BI Desktop is empty (only column headers, no rows). 

Is this a bug in PBI Desktop? My version is : 2.51.4885.701 64-bit (October 2017)

[v-haibl-msft]

@rylach

Are you able to see the table and columns in Report view - FIELDS in the right pane?

If you create a Table visual and drag the columns into it, is there any data in the Table visual?

In the Data view, what is the result if you click the column header and click Refresh?

If you do not make any transform in Query Editor (just get data from the SQL DB), will this issue persist?

Best Regards,
Herbert

[rylach]

ad 1)

Yes

ad 2)

Nope, I can't see anything if I choose any field other then the one being a key for relation to other (calendar) table. If I put the one column as first value into Table visual - I can see calendar's values, but every other column displays no data.

ad 3)

The data has been loaded properly .

ad 4)

Nope. It is enough to modify the last step (remove one column from the list of columns to be removed), If I change anything and click 'Close and apply', then the data does refresh and appears in Data view.

Ryszard.

[rylach]

Update: after upgrade to Novembers's version the issue persists.

[v-haibl-msft]

@rylach

For the third question, if you click the column header and click Refresh, the data will be loaded properly. Will the data also be displayed in Data view?

If possible, could you please share your PBIX file through online file service like OneDrive?

Best Regards,
Herbert

[rylach]

Yes, I'm refreshing in Data View and it is loaded and visible in Data View.

I can share the file, but only if I will be sure it remains private for Power BI Support. Can I be sure that ?