missing data in Power Query

[XLBob]

Somthing very weird happend to my Power BI desktop recently and haven't happened before. Problem is I downloaded a PBIX file which I published before from powerbi.com and I can see data in data view. However the table is empty in Power Query window. If I refresh my PBIX file, then the table will be empty in Data view as well. I then publish the same PBIX file and refresh the dataset on the cloud using data gateway, I can see data again. Has anyone else had the same issue?can see data in Data ViewNo Data in Power Query Window

[Seward12533]

Can you share the M (advanced editor) code for your queries? Not much to go on in our post.

[XLBob]

let
Source = Sql.Database("paomsdb4200", "AssessmentsDM"),
dbo_vw_FactProject = Source{[Schema="dbo",Item="vw_FactProject"]}[Data],
#"Filtered Rows" = Table.SelectRows(dbo_vw_FactProject, each [SnapshotCurrentFlag] = true),
#"Merged Queries1" = Table.NestedJoin(#"Filtered Rows",{"ExtensionKey"},ProjectDetail,{"ExtensionKey"},"NewColumn",JoinKind.LeftOuter),
#"Expanded NewColumn1" = Table.ExpandTableColumn(#"Merged Queries1", "NewColumn", {"PType", "Status", "Project With Dept Or Prop"}, {"NewColumn.PType", "NewColumn.Status", "NewColumn.Project With Dept Or Prop"}),
#"Filtered Rows1" = Table.SelectRows(#"Expanded NewColumn1", each [NewColumn.Project With Dept Or Prop] <> null),
#"Merged Queries" = Table.NestedJoin(#"Filtered Rows1",{"ProjectGroupKey"},Branch,{"ChildProjectGroupKey"},"NewColumn",JoinKind.LeftOuter),
#"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"Branch Name"}, {"NewColumn.Branch Name"}),
#"Filtered Rows2" = Table.SelectRows(#"Expanded NewColumn", each [NewColumn.PType] = "Part3A" or [NewColumn.PType] = "Part3AMod" or [NewColumn.PType] = "SSD" or [NewColumn.PType] = "SSI" or [NewColumn.PType] = "SSD Mod" or [NewColumn.PType] = "SSI Mod")
in
#"Filtered Rows2"

it's all just normal merge, filter and replace. This has been working fine until last week where it returned no data. If I write a sql code in SSMS and I do see data

[XLBob]

by the way, I am microsoft certified so I know Power BI very well. it just bizzare.

[v-yuta-msft]

Hi XLBob,

I have made a test on your issue but can't reproduce your issue, please refresh the report and check if the data can be seen in power bi desktop. If still can't see, can you share a sample file for further analysis?

Regards,

Jimmy Tao

[XLBob]

Never mind. You can't really reproduce the issue as you won't be able to refresh the workbook. When I open right after download from Power BI.com, it's all good. Problems comes when I refresh the workbook. But luckily, it's all good once it's on the cloud. 

I have also tested the same workbook on my colleague's laptop and we all have the same issue. No idea what's going on. 

I have tried to reproduce the same issue with AdventureWorks sample data in my AzureSQLDW and it's all working fine.

Anyway, I will park this for now as it may fix itself some day.