Using legacy dataflows I can see data in the dataflow but not in desktop.

[Morcreative]

I have created several dataflows (legacy) in Service with SQL queries as the source and refreshed them . I can see data there, but not in desktop. I have tried refreshing both consectutively. I even reduced one dataflow to a single field as a test and still the desktop table is empty.

[v-xinruzhu-msft]

Hi @Morcreative 

1.Please check that if it has the date column in your flow, if it exists, change the type to date/time, then when load to Power BI desktop, then change its type to date, and you can refer to the following thread.

Dataflows - No entity after refresh - Page 2 - Microsoft Fabric Community

2.Check if the certification is right,  try to clear the permission at Data source settings(File->Options and settings->Data source settings), then connect the dataflow again in Power BI Desktop.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Morcreative]

I have created a test dataflow with only one text column. It also shows the table is empty after refreshing the dataflow in service and then refreshing the dataflow in desktop. I have have also tried clearing permissions to no avail. The interesting thing is, if I publish my sematic model back out to service, the data is there.