Imported web csv data not able to transform

Hi DieterD 

Based on the code you have offered, your url should be the path that the csv file located. 

it sholuld be "https://..../ACF2.csv", you can try the following

Source = Csv.Document(Web.Contents("http://"IP adres"/DataLogs?Path=/DataLogs/ResultDataFillingEquipment_ACF2.csv", [Headers=[Referer="http://"IP adress"/Portal/Portal.mwsl?PriNav=DataLogs"]]),null,{0, 117, 164, 185, 206},ExtraValues.Ignore,1252)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks. The example file does not look very special.

And I was wondering: Do you want the file in 4 fixed columns to start with? And how did you get the second query?

Below the query if you just want all columns in the file as they are in the CSV file. You can refer to this querey for further processing...

If you just want the 4 fixed columns, then just forget about the second query.

let
    Source = Csv.Document(
        Web.Contents(
            "http://"IP adres"/DataLogs?Path=/DataLogs/ResultDataFillingEquipment_ACF2.csv&Action=DOWNLOAD"
            , [Headers=[Referer="http://"IP adress"/Portal/Portal.mwsl?PriNav=DataLogs"]]
            )
        , null  // defaults to ","
        , null // or replace by the number of colums you are interested in. // was {0, 117, 164, 185, 206}
        , ExtraValues.Ignore // ignores columns you are not interested in (if any)
        ,1252  // Is the windows Encoding, I assume it is correct for your data
        ),
    #"First Row as Headers" = Table.PromoteHeaders(Source) // was: #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}})
in
    #"First Row as Headers"