Datamart Internal Error 500 when using dataflow

[kblackburn]

Using dataflow as a source in datamart and getting repeated errors on "wrapping up". Have tried both dataflow connectors and same issue.  Please help!

Activity ID: undefined
Request ID: undefined
Status code: 500
Error Code: InternalError
Batch ID: 078da941-9ebe-40cc-b68c-6691e61b37d8@4960c16c-7c39-4b2b-b3fa-1638403fba8b$2022-09-30T20:43:27.1825502Z@30c4a734-2c9d-4da5-b0e1-0c3063966dd2

[Anonymous]

Hi @kblackburn 

Can your dataflow work normally ? At which step did you get this error?

Best Regards,
Community Support Team _ Ailsa Tao

[kblackburn]

Hi @Anonymous thank you for your reply.  Yes, my flow is working perfectly normal. I can bring the data in via the flow connector. The error occurs during the "wrapping up" stage -see below:

[tsnyd111]

I'm getting a similar error when I use dataflows to load a Datamart. 

[kblackburn]

@tsnyd111 

My issues was related to this. Once I disconnected from Gen2 storage, everything worked fine.

• Datamarts aren't available in workspaces that are bound to an Azure Data Lake Gen2 storage account

Best of luck!

[tsnyd111]

@kblackburn 

My understanding is all workspaces default to Azure Data Lake Gen2 for underlying dataflow outputs; how'd you disconnect?

Is there a workaround that allows Power BI dataflows to load into a datamart (without hitting this error)?