Forum Discussion
Table has no rows
Hello PinballWizard , you seem to know what you doing but just want to make sure at the time of data pull from dataflow, does it say its still refreshing?
this seems to be an issues in majority cases. if dataflow is in the process of refresh it will not show any data except for column names untill refresh has completed.
Hi BiAnalyst . Thanks for your response. Scheduled refreshes were set up to run daily at 2AM due to the volume of data being consumed so as not to interfere with system performance during the day. However these refreshes kept failing. The error messages I kept on receiving were that the most downstream dataflow contained errors relating to a column name however there was no mention of this column name in the M code within this dataflow. This also affected the dataflows upstream for some reason.
Today I decided to copy and paste the M code of the erroring dataflow into notepad and delete it. Then I refreshed the upstream dataflows like you suggested and they seemed to then work. It meant I had to build the deleted dataflow again from scratch with reference to the M code that I copied which took all afternoon but it is now working again.
It's incredibly frustrating that there isn't a better way to interrogate, test and debug any errors raised. Even if the source of the error was a column name/type mismatch there was no clear way of identifying and rectifying.
However it is now working thanks to your suggestion so thanks very much for your input. 🙂
Cheers