Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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
Solved! Go to Solution.
I found a code that worked :
PowerBiFunctions/ZipFile/Unzip.m at main · Michael19842/PowerBiFunctions · GitHub
I found a code that worked :
PowerBiFunctions/ZipFile/Unzip.m at main · Michael19842/PowerBiFunctions · GitHub
There 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-...
| User | Count |
|---|---|
| 12 | |
| 6 | |
| 6 | |
| 5 | |
| 5 |