Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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-...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
29 | |
26 | |
23 | |
13 | |
10 |
User | Count |
---|---|
24 | |
21 | |
17 | |
11 | |
9 |