Skip to main content

    Power BI

    New

    Open document

    Vote (11) Share
    Jon Bell's profile image

    Jon Bell on 28 Feb 2018 20:35:57

    I would like the ability to connect to .ODS (open document spread sheet) sources from the web, I can open the files on this webpage: https://www.gov.uk/government/statistical-data-sets/fire-statistics-data-tables#incident-level-datasets in Excel and it converts them but when trying to connect to this type of file directly in Power BI Desktop I receive the following error: DataFormat.Error: External table is not in the expected format.

    Comments (1)
    Jon Bell's profile image Profile Picture

    0c542b52 7dc6-ea11-a812-000d3a9b112e on 15 Jul 2020 09:32:09

    RE: Open document

    yes please, this would be really useful for me - saves running powershell scripts to download the data, convert to excel load into sql and then call from sql!