topic Re: Not able to save destination settings for Dataflow Gen2 in Dataflow

Not able to save destination settings for Dataflow Gen2

ThomasPyndt — Mon, 08 Apr 2024 11:13:59 GMT

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?

Re: Not able to save destination settings for Dataflow Gen2

anros — Mon, 08 Apr 2024 14:04:03 GMT

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

Re: Not able to save destination settings for Dataflow Gen2

anros — Wed, 10 Apr 2024 10:22:42 GMT

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

Re: Not able to save destination settings for Dataflow Gen2

ThomasPyndt — Wed, 10 Apr 2024 13:41:43 GMT

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

Re: Not able to save destination settings for Dataflow Gen2

v-cboorla-msft — Wed, 10 Apr 2024 17:19:12 GMT

Hi ThomasPyndt

Glad that you got some insights on your query.

Please continue using Fabric Community on your further queries.

Thanks.

Re: Not able to save destination settings for Dataflow Gen2

anros — Thu, 11 Apr 2024 09:24:25 GMT

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