Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
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-...
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 12 | |
| 11 | |
| 11 | |
| 7 | |
| 6 |