Updating or adding data sources to data flow fails

[Anonymous]

When i try to update or add data to new or existing data flows, it fails when I hit Save and Close. It happens on all kind of data sources, and the error message appears instantly, withhout any spinning wheels or other thing indicating that something is beeing validated.

This started yesterday. Has anyone else experienced the same and is there something i could do to fix this?

There was an unexpected error.

SessionId: af1c6647-f330-4984-8a32-2ff9308cbee2

section Section1;
shared Endringslogg = let
Kilde = Csv.Document(File.Contents("\\bigateway\powerbi\Endringslogg.csv"), [Delimiter = ";", Columns = 8, Encoding = 65001, QuoteStyle = QuoteStyle.None]),
#"Forfremmede overskrifter" = Table.PromoteHeaders(Kilde, [PromoteAllScalars = true]),
#"Endret kolonnetype" = Table.TransformColumnTypes(#"Forfremmede overskrifter", {{"ID", Int64.Type}, {"AuthorName", type text}, {"AuthorScreenName", type text}, {"ProfilePic", type text}, {"Date", type date}, {"Text", type text}, {"Likes", Int64.Type}, {"Retweets", Int64.Type}})
in
#"Endret kolonnetype";

[Rutger_IVAR · Accepted solution]

I changed the language settings from Default (browser language) (Norwegian) to English and now it seems to work for me. 

[Anonymous]

Thanks, @Rutger_IVAR , it worked. 😊

[Rutger_IVAR]

Hi @Anonymous, @v-luwang-msft 

Same problem here for our customer when trying to update connection string to a new SQL server.

Updating the dataflow works great but cannot save and close the Power Query editor.
I tried to create a new dataflow from a flatfile, this also results into the same unknown error.

Maybe it has something to do with our language settings? (Norwegian) 

/Rutger

[v-luwang-msft]

Hi @Anonymous ，

Try to create a new data flow and connect to  "\\bigateway\powerbi\Endringslogg.csv".

Check if it is feasible.

Best Regards

Lucien

[Anonymous]

Thanks for the reply, @v-luwang-msft .

To connect to the data works flawlessy for all sources, i'm able to see and transform the data. But when I want to save and close the flow - the error appears. It doesnt matter if do a lot of transformations or alomst nothing. The data is fetched through a on-premise gateway, updated last friday.