Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DataFlow - table is empty when connecting with Desktop

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 But when I try to use it in Power BI Desktop t...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.