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

quizhyo's avatar
quizhyo
Advocate I
3 years ago

It doesn't work for me. Do you have another solution?

PtoLtoC's avatar
PtoLtoC
Frequent Visitor
3 years ago

Hey,
I had the same issue, dataflow appeared with rows but when I get data from it, it shows as empty.
The issue was the relation with another dataflow, indeed the refresh was linked to another dataflow for which it failed.
Check in the folder view if all refreshes worked well, then fix potential fails.

  • quizhyo's avatar
    quizhyo
    Advocate I
    2 years ago

    Thank PtoLtoC 

    This issue happened a long time ago in 2023, as I remember that I had to check the cleaning data process; adding one more step "Remove Error" in the final step 

    Datamart just shows about 1000 rows. So, if there are errors in row 1001. We can't know 

    => adding 1 more step remove error