Dataflows not populating tables

[Anonymous]

Hi,

I'm currently having issues with dataflows not populating data across my linked dataflows. My current set up is as follows:

SQL server -> Staging dataflow -> Transformation dataflow

I can see all the data within staging and have connected to the tables within transformation, but in transformation I receive "this table has no rows" for just a few of the tables only. Has anybody got a remedy for this? 

[ibarrau · Accepted solution]

Hi Burner. I can think about one thing for now. Be sure that you are running a refresh of each dataflow in order. Each time you add a new table to a dataflow it won't load untill you literally run a refresh of the data. When you finish your work with a dataflow and click save it won't bring data, it will only validate code.

That can be the reason of no data. Run a refresh for staging and the for transformation!

I hope that helps,