Forum Discussion
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";
- Anonymous4 years ago
I changed the language settings from Default (browser language) (Norwegian) to English and now it seems to work for me.
5 Replies
- AnonymousNot 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
- AnonymousNot applicable
I changed the language settings from Default (browser language) (Norwegian) to English and now it seems to work for me.
- AnonymousNot applicable
Thanks, Anonymous , it worked. 😊
- v-luwang-msftCommunity 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
- AnonymousNot 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.