Forum Discussion
Unzip csv file - getting an error
Hi -
I am new to power BI. I get zipped files from third party every week. Each zipped file has one csv file in it. I used the code mentioned in Reading Zip files in PowerQuery / M (sql10.blogspot.com).
However, I am getting the following error
Expression.Error: The number is out of range of a 32 bit integer value.
Details:
4294967295
When compressed my files are about 180KB and ~1000KB when uncompressed. The csv file is a combination of date, text and number columns. None of the numbers are as big as mentioned in the error.
Any help would be appreciated.
TIA
I found a code that worked :
PowerBiFunctions/ZipFile/Unzip.m at main · Michael19842/PowerBiFunctions · GitHub
2 Replies
I found a code that worked :
PowerBiFunctions/ZipFile/Unzip.m at main · Michael19842/PowerBiFunctions · GitHubThere is no guarantee that the file size is actually recorded in the first header. Use code that reads the file size from the directory in the back of the zip.
If you can, post a sample zip file. If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
