Skip to main content

    Power BI

    Needs Votes

    Ability to import compressed plain text files (i.e in a Zip file)

    Vote (29) Share
    Paulie's profile image

    Paulie on 24 Sep 2015 02:30:14

    Ability to import plain text files that are contained within a standard Zip file. This will reduce the amount of time required to transmit the files to PowerBI / PowerQuery / PowerBI Online.

    Comments (3)
    Paulie's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:22:39

    RE: Ability to import compressed plain text files (i.e in a Zip file)

    You can achieve this with a function - see my blog for details:
    http://sql10.blogspot.co.za/2016/06/reading-zip-files-in-powerquery-m.html

    Paulie's profile image Profile Picture

    Greg Baldini on 05 Jul 2020 22:13:59

    RE: Ability to import compressed plain text files (i.e in a Zip file)

    The compression in a Power BI Data Model is excellent, as is compression on text-based flat files. It's terribly inconvenient to unpack a csv, for example, only to import the data into another compression format. Adding native decompression would be great to import already compressed data without needing 10x the disk space.

    Paulie's profile image Profile Picture

    Mike Honey on 05 Jul 2020 22:13:20

    RE: Ability to import compressed plain text files (i.e in a Zip file)

    This seems fairly easy - just an extension of the existing From Folder functionality. That way it would work with all file formats (Excel, JSON etc).