Importing an .ics file - calendar

[vanessafvg]

does anyone know the best way of importing an .ics file into power bi?

[v-yuezhe-msft · Accepted solution]

@vanessafvg,

I made a test using attached ICS file, and transfrom the data in Query Editor using the code below. Please check if you get expected data using these transform steps.

let
    Source =Table.FromValue({Text.FromBinary( File.Contents("folderpath\sample.ics"))}),
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Value", Splitter.SplitTextByDelimiter("BEGIN:VEVENT", QuoteStyle.Csv), {"Value.1", "Value.2", "Value.3", "Value.4", "Value.5", "Value.6", "Value.7", "Value.8", "Value.9", "Value.10", "Value.11", "Value.12", "Value.13", "Value.14", "Value.15"}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Split Column by Delimiter", {"Value.1"}, "Attribute", "Value"),
    #"Split Column by Delimiter1" = Table.SplitColumn(#"Unpivoted Other Columns", "Value", Splitter.SplitTextByDelimiter("#(cr)#(lf)", QuoteStyle.Csv), {"Value.1.1", "Value.2", "Value.3", "Value.4", "Value.5", "Value.6", "Value.7", "Value.8", "Value.9", "Value.10", "Value.11", "Value.12"})
in
    #"Split Column by Delimiter1"

Regards,
Lydia

[vanessafvg]

thanks ill give it a bash