Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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,
Happy to help!
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,
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.