Not able to save destination settings for Dataflow Gen2

[ThomasPyndt]

Hi

I am using a Dataflow Gen2 to obtain a bunch of different CSV files, all of them more or less like so:

let
  Source = Csv.Document(Web.Contents("https://api.XXXXX.com/reports/BLD?apiToken=YYYYYYY"), [Delimiter = ",", Encoding = 65001, QuoteStyle = QuoteStyle.None]),
  #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars = true]),
  #"Changed column type" = Table.TransformColumnTypes(#"Promoted Headers", {{"Fuel Price", type number}, {"Lifting ID", Int64.Type}})

in
#"Changed column type"

In the data flow destination I am choosing a Lakehouse.

This works fine for 25 out of 27, but for two of them, I cannot get past the "Choose destination settings" screen.

When I click "save settings", nothing happens

I got tired of trying to fix it, so I moved on to some of the other CSV documents, which worked like a charm, but when returning to the two they both get stuck at the am. screen.

Has anyone experienced this? Is there a known issue here?

[ThomasPyndt]

Hi Antoine

Thank you very much for your prompt attension and solution - works like a charm!

Should I add it as a solution in the forum or would you rather just deploy the fix?

Kind regards

Thomas

[v-cboorla-msft]

Hi @ThomasPyndt 

Glad that you got some insights on your query. 

Please continue using Fabric Community on your further queries.

Thanks.

[anros · Accepted solution]

For reference if anyone else face this issue in the next 2 weeks, this is currently a bug as all the columns contain a space.

This issue will be treated with high priority but as a workaround, make sure at least one column does not contain a space when loading to Lakehouse.

Best Regards,

Antoine

[anros]

Fix is being rolled out and should be available next week in all regions

[anros]

Hi @ThomasPyndt,

Would you mind sharing a session id of a repro with me by private message ?

It can be found on the ribbon menu under "Options" then "Diagnostics". You can the right click and copy the value.

Thanks