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
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.

quyenduong's avatar
quyenduong
Helper II
3 years ago

I did all transformation steps in dataflow and check each step, no error at all, I can also see the data from dataflow

But when I connect it to create a new power report, the table is empty, do you know why and how can i solve this?

  • rdnguyen's avatar
    rdnguyen
    Helper V
    3 years ago

    Export that dataflow and import it again, refresh the new dataflow, then try to connect it as datasource for your power bi desktop. It worked for me before.