Forum Discussion
Can't find dataflow
- Anonymous2 years ago
Hi DennesTorres
We haven’t heard from you on the last response and was just checking back to see if you can provide the details asked above. This helps us in understanding the issue and help you better.
Thanks - 2 years ago
Hi,
Your troubleshooting steps and some investigation with the support managed to solve the problem.
The solution: Dataflows are not visible to the Dataflow activity in pipelines before they are published.
Well, it seems to make sense, except for one detail: When the dataflow is "Published" it is Executed. Sometimes, like on the situation I have in hands, I had no intention to execute the dataflow outside the orchestration of the pipeline.Luckly, it was possible to workaround and execute, but I keep imagine situations where it wouldn't make sense.
It seems a pending improvement.Kind Regards,
Dennes
Hi,
It's not during execution, the error happens when selecting the dataflow in the dropdown, so I can't select it.
Yes, the dataflow is in the same workspace as the pipeline.
I remember, from data factory, some name requirements on the dataflows, so I tried to rename it, removing spaces and leaving everything lowercase, but it didn't solve the problem. I still think it's some not so obvious requirement not fulfilled.
Kind Regards,
Dennes
Hi DennesTorres
Is it the same in all the workspaces? Or this is happening only in this workspace? Is the Dataflow published successfully? If so, how recently?
Try creating another dataflow and check. Is the Dataflow published recently?
Please let me know if the issue persists.
- Anonymous2 years agoNot applicable
Hi DennesTorres
We haven’t heard from you on the last response and was just checking back to see if you can provide the details asked above. This helps us in understanding the issue and help you better.
Thanks- avilasebastian1 year agoRegular Visitor
Hello !!
so, microsoft made contact with me and we saw the issue in a call.
The solution for me was to enable the Gen1 dataflow in the admin portal. Microsoft team detected the error with the logs of the request while refreshing the dataflow list noticing an unauthorized statment. 1 minute after clicking the enable button the pipeline was able to list the dataflows.
Hope you can fix it the same way !Sebastian A.
- momajasa1 year agoRegular Visitor
Hello .. thank you so much - problem solved.
- DennesTorres2 years agoPower Participant
Hi,
- I haven't tested in different workspaces.
- I haven't published the dataflow. Published=run . The execution will only be complete when done from the pipeline.
- There are 3 dataflows in the workspace. None of them appear in the pipeline, on the dropdown.
Kind Regards,Dennes
- DennesTorres2 years agoPower Participant
Hi,
Your troubleshooting steps and some investigation with the support managed to solve the problem.
The solution: Dataflows are not visible to the Dataflow activity in pipelines before they are published.
Well, it seems to make sense, except for one detail: When the dataflow is "Published" it is Executed. Sometimes, like on the situation I have in hands, I had no intention to execute the dataflow outside the orchestration of the pipeline.Luckly, it was possible to workaround and execute, but I keep imagine situations where it wouldn't make sense.
It seems a pending improvement.Kind Regards,
Dennes
- momajasa1 year agoRegular Visitor
Hello Anonymous
this issue still persists and it's causing my firm some big issue during a BC Go-Live in combination with MS Fabric Power BI Reports.
The Dataflow is supposed to run every 5 minute to load BC Data into Fabric, but it's not visible in the drop-down list of the data pipeline's dataflow activity.
I have tried all the mentioned steps several times without luck:
- Dataflow Gen2 is published
- Workspace is fabric enabled (even 3 different workspaces)
- creating new dataflow didn't solve the problem
I have used dataflows in pipelines across several projects and never faced anything like this.
Please let me know of any Tenant Level Setup necessary to enable this - this is supposed to be a core feature and besides the fact that Microsoft has caused us a huge amount of shame facing our customers by not enabling git integration and other basic data engineering features for dataflows, such occurences make customers second guess if MS Fabric was the right way to go.
Please fix these things before implementing any new fancy features to MS Fabric, it's making life hell for us.
Thank you for your understanding