Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Datamart Internal Error 500 when using dataflow

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

Status: Investigating

Hi @kblackburn 

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

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Investigating

Hi @kblackburn 

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

 

Best Regards,
Community Support Team _ Ailsa Tao

kblackburn
Advocate I

Hi @v-yetao1-msft 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:

kblackburn_0-1664921053292.png

 

tsnyd111
Frequent Visitor

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

tsnyd111_0-1683962409999.png

 

kblackburn
Advocate I

@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
Frequent Visitor

@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)?