Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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-...
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 16 | |
| 12 | |
| 9 | |
| 6 | |
| 6 |