Dataflow Gen 2 DataflowsStagingWarehouse error

[Anonymous]

Hi,

When trying to run a Dataflow Gen 2 without a data destination I get an error that the accces is denied. Somehow this used to work in the past, but not anymore. I am the owner of the dataflow.

Error Code: Mashup Exception Data Source Error, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataSource.Error: Microsoft SQL: CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file

DataflowsStagingWarehouse;Message = CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file

Anyone have any advice why this is not working anymore? It only works when adding a data destination, however, would prefer not to use a data destination. Just load the data from the dataflow straight into Power BI.

[JohanLudvig]

I just tested a similar dataflow gen2 approach, and that worked. So are there any user constraints involved?

As in - user lost access to the Fabric resources, or capacity/workspace restrictions imposed?

[Anonymous · Accepted solution]

The Workspace was created by an employee that left. After creating a new Fabric workspace it worked.

[Anonymous]

Hi,@Anonymous .
Hello,@ibarrau ,@JohanLudvig ,thanks for your concern about this issue.

Your answers are excellent!
If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian.

[ibarrau]

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,

[Anonymous]

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?