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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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