DataFlow - table is empty when connecting with Desktop

[mihalykavasi]

Hi everyone!

I have an issue with dataflows.

I created a simple dataflow using a SharePoint List.

I can see the data in the dataflow editor

DataFlow - Editor

But when I try to use it in Power BI Desktop the table is empty.

DataFlow - Navigatior

DataFLow - No data

I was not able to solve this issue so far.

Any idea?

Thanks,

Mihaly

[sciomac]

Hi everyone,

I've got the same problem, I have created 3 dataflows:

1. From Excel file: No problem at all
2. From Template Dynamic 365 Sales: I have refreshed after creating and I've checked that there is data but when I tried with PB Desktop, it tells me that tables are empty. I have also refreshed the navigator.
3. From SQL Server: I have refreshed after creating and I've checked that there is data but when I tried with PB Desktop, it tells me that tables are empty. I have also refreshed the navigator.

Power Query Editor Online

PB Desktop

Can anyone help me, please?

Thank you

[marks789]

Found the solution that works for me here-  https://community.powerbi.com/t5/Service/DataFlow-table-is-empty-when-connecting-with-Desktop/m-p/84...

[v-yulgu-msft · Accepted solution]

Hi @mihalykavasi ,

After creating the new dataflow, please refresh the DataFlow on service to make data loaded into the entity. Then, click the "Refresh" button in "Navigator" pane. If still no data is shown, please clear permissions under "Data Source settings", and establish the connection to dataflow again.

Best regards,

Yuliana Gu

[anoopshar]

@v-yulgu-msft ,

I have tried all the suggested options but none of them worked. Tried refreshing data in PowerBI service, tried refreshing data in Navigator, tried refreshing data in Preview pane, tried clearing the permissions but it still shows "The table is empty". Any suggestions?

[MatheusNunes]

I had the same problem, apparently, the data is not loaded in Power Bi Desktop if any column has an error. In my case, a transformation was trying to parse a list column in text and the value only shows "error", removing this transformation all worked.

[mihalykavasi]

If you go back to the dataflow and start editing it. Do you see the data? Also have you checked in the service if the data flow refresh was successful?