kblackburn's avatar
kblackburn
Advocate I
3 years ago
Status:
Investigating

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

Data Modeling

5 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi kblackburn 

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

     

    Best Regards,
    Community Support Team _ Ailsa Tao

  • kblackburn's avatar
    kblackburn
    Advocate I
    3 years ago

    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's avatar
    tsnyd111
    Frequent Visitor
    3 years ago

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

     

  • kblackburn's avatar
    kblackburn
    Advocate I
    3 years ago

    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's avatar
    tsnyd111
    Frequent Visitor
    3 years ago

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

Completed Ideas