search

sql-bi / Bravo

Bravo for Power BI
MIT License
344 stars 88 forks source link

Issue with exporting big fact table - how to activate Zip64 option #796

Closed FrankG1965 closed 1 month ago

FrankG1965 commented 1 month ago

Describe the problem

Error 700: Something wrong happened while exporting data. Please try again. Attempted to write a stream that is larger than 4GiB without setting the zip64 option

Bravo version

1.0.8 (1.0.8868.14547)

Tabular model

Power BI Desktop, import mode

Power BI

PBI June2024

Steps to reproduce the behavior

No response

Additional context

Trying to export big file. After 75% progress the error messages comes. How can I activate the zip64 Option?

Screenshots

image

Anything else ?

Trace Id: 00-7de9504e928c9d00ae45e9cffb124665-472cb8866555dbf8-00

albertospelta commented 1 month ago

@FrankG1965, the Zip64 option is internal and not configurable in the current version. However, we have released an update that allows enabling this option by holding down the CTRL key while clicking the Export Selected button.

When enabled, the diagnostic log panel displays the Experimental feature: useZip64 is enabled message as shown below.

image

This feature is available in the latest internal build and will be included in the next public release. To access the latest internal build, switch the update channel from Stable to Dev in the Options/About panel, and follow the provided link to download the installer.

Could you please test it and let us know if it works as expected?

[!WARNING] Please note that this feature is experimental and disabled by default because, in some cases, it may generate invalid XLSX files that might not open correctly in Excel or LibreOffice. Due to this, and to avoid hitting the fixed 1 million rows per worksheet limit in Excel, we recommend using CSV instead of Excel spreadsheets for exporting large volumes of data.

albertospelta commented 1 month ago

@FrankG1965 This functionality has been released in version 1.0.9. I am closing this issue, but feel free to reopen it if you encounter further issues or have additional questions. Thanks!