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?
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,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
