Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Updating or adding data sources to data flow fails

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";

  • Anonymous's avatar
    Anonymous
    4 years ago

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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks, Anonymous , it worked. ğŸ˜Š

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support

    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's avatar
      Anonymous
      Not applicable

      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.