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

mkash's avatar
mkash
Regular Visitor
4 years ago

Try to follow this strategy:

 

1. Avoid changing data types in dataflows. Keep all columns as strings as much as possible.

2. Check for column quality and avoid any types of errors.

3. Process data a less as possible in dataflows. Use dataflows only a data collection and data connection point.

 

I had the same problem, I solved mine by removing all data type changes from my data. Once, I import it in power bi, I changed data types as I wished.

 

Hope that helps.