Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

kblackburn

Datamart Internal Error 500 when using dataflow

Submitted by Advocate I on ‎09-30-2022 02:16 PM

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
See more ideas labeled with:
5 Comments (5 New)
Comments
Anonymous
Not applicable
‎10-03-2022 10:27 PM

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
Advocate I
‎10-04-2022 03:05 PM

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:

kblackburn_0-1664921053292.png

 

tsnyd111
Frequent Visitor
‎05-13-2023 12:20 AM

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

tsnyd111_0-1683962409999.png

 

kblackburn
Advocate I
Advocate I
‎05-15-2023 08:53 AM

@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
‎06-08-2023 02:49 AM

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

Idea Statuses