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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
FredrikJ
Helper III
Helper III

Problem running a gen2 dataflow from a non azure sql server via a gateway to a Lakehouse

Hi!

 

I have set up a gen2datflow from an oracle database via gateway (version number 3000.178.3) and everything looks fine in the dataflow I can my data. Destinations of the dataflow is to a lake house and it works fine to publish the Dataflow but when refreshing the Dataflow it fails with no error message

 

FredrikJ_0-1685093570473.png

Regards

Fredrik

2 ACCEPTED SOLUTIONS
SidJay
Microsoft Employee
Microsoft Employee

The most recent version of the Gateway (version 3000.174.12 uploaded on May 30th) addresses the "We don't support creating directories in Azure Storage unless they are empty" error.

View solution in original post

Anonymous
Not applicable

Hi,

 

It works ! Thanks a lot for the quick fix

View solution in original post

17 REPLIES 17
FilipVDR
Helper I
Helper I

Seems i got a similar error: even when I create a new dataflow and enter data with one column and one row, and I want to write it to the lakehouse i get an error: 

 

FilipVDR_0-1685432725653.png

 

It seems that the dataflow can't save my connection using my Organizational Account

RRPowerBiAdmin
Frequent Visitor

Similar problem with DF Gen 2 with Lake house target. Simple one column hand entered table. For testing.  DF runs fine. Target won't keep saved credentials despite being entered repeatedly and seeing the destination in the saving and publishing steps...F9ACFA8E-430A-4032-A31B-FD40F2FEA2E9.jpeg7C92BDB1-E112-4601-83C9-F6FA2DCD9BD1.jpeg24F0F275-9C4C-4905-A073-770E108993B9.jpeg

Hey! 

As mentioned in the other thread, the problem that you're mentioning seems to be unrelated to the gateway related issue. I'd highly recommend reaching out to the support team to go deeper into this issue and possibly find a solution. 

if there's no gateway involved in your dataflow, then the problem will be someplace else in our stack.

miguel
Community Admin
Community Admin

Hi all!

 

The product team has been notified of the issue which is in relationship to the Gateway. They're working hard on pushing out a new version of the gateway that will have the fix for it. 

 

Thank you for your patience!

suidino2
Frequent Visitor

Same error here. 

Dataflow pulling from on-premise SQL-server by using enterprise gateway (updated to latest version)

Dataflow destination setup to lakehouse. Dataflow itself setup successfully, but when tried to refresh the dataflow, it appears the same error message. 

miguel
Community Admin
Community Admin

@FredrikJ @ce87 Thank you for confirming this! please go ahead and raise a support ticket so an engineer can look deeper into it

miguel
Community Admin
Community Admin

Hi @FredrikJ @ce87 ,

 

Would you mind updating to the latest version of the gateway and try again? Let us know if you're still any errors after updating the gateway

I have the latest version installed.

SidJay
Microsoft Employee
Microsoft Employee

The most recent version of the Gateway (version 3000.174.12 uploaded on May 30th) addresses the "We don't support creating directories in Azure Storage unless they are empty" error.

@SidJay I uploaded the Gateway on May 26th and got a higher version (3000.178.3) then you talking about. Is it possible for us to install a version with lower version number then we already got? And how can i be possible for us to have a higer version when we uploaded our version before u did?

Regards

 

Fredrik

SidJay
Microsoft Employee
Microsoft Employee

Hi Frederik,

 

I'm unfortunately not sure how you could have gotten into that state. The most prudent course of action would be to uninstall the prior installation, and then install version 3000.174.12.

Hi @miguel !

 

I updated the gateway today to version number 3000.178.3. And still got the same problem.

 

Regards

Fredrik

ce87
Advocate I
Advocate I

What error message are you getting? If you click on the Table Name (DART) is should give you the error message.

 

I'm having siliar issues. I'm getting this error;

 

Error Details: Error: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: We don't support creating directories in Azure Storage unless they are empty. Details: #table({"Content", "Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}, {}) GatewayObjectId: b4a8b741-aef4-482e-9d30-19d6dea19022. Request ID: 78757b74-d18e-c8c3-6e24-7c16331d838d. (Request ID: 2dfa424a-69ea-41c2-a61a-82484f43eee7).

Anonymous
Not applicable

Hello, 

I have exactly the same error than you after I have updated the Gateway. 

Did you find any solution yet ?

 

Thanks,

David

SidJay
Microsoft Employee
Microsoft Employee

The most recent version of the Gateway (version 3000.174.12 uploaded on May 30th) addresses the "We don't support creating directories in Azure Storage unless they are empty" error.

Anonymous
Not applicable

Hi,

 

It works ! Thanks a lot for the quick fix

Yes, I see now I get the same errormessage:

Error Details: Error: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: We don't support creating directories in Azure Storage unless they are empty. Details: #table({"Content", "Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}, {}) GatewayObjectId: 89d69b05-cbca-4382-b000-c8c76058d4ed. Request ID: a0a20bcc-958f-09b6-c6bd-bdfab9bf796f. (Request ID: 4a0c7012-c9ec-417a-8029-e2281b52a919).

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

November Update

Fabric Monthly Update - November 2024

Check out the November 2024 Fabric update to learn about new features.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.