Forum Discussion
Dataflow Gen 2 DataflowsStagingWarehouse error
The Workspace was created by an employee that left. After creating a new Fabric workspace it worked.
Hi. The way Dataflow Gen2 works it's storing the data in a Fabric lakehouse. That can be done in two ways. One it's configuring the destination, and another is setting a staging (that stores it in a black box lakehouse). Both of them requires Fabric. The way you are talking like "running a dataflow and store in power bi" that sounds like Power Bi Dataflow the first generation. You can still create that content if you want, just click New -> PowerBi -> Dataflow. That one will let you connect with Power Bi and it stores the data in a hidden black box shared capacity that you won't see with any other tool rather than Power Bi Desktop.
I hope that helps,
Thank you for the reply, much appreciated.
I do work in a Fabric workspace. So when I enable staging in the Gen 2 workflow I get an error which contains that my access is denied to the stagging warehouse: DataflowsStagingWarehouse;Message = CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file
Which is strange, I am an admin of the workspace. Is there any setting that I am missing?