Forum Discussion
OLE DB or ODBC Error:[DataFormat.Error] invalid excel - Resolved by reducing file size
Depending on your description, you are using the import mode.
With this method, the data from the source will be uploaded to Power BI. Uploading to Power BI means consuming memory and disk space. As long as you're developing Power BI on your computer with Power BI Desktop, it would be machine memory and disk space. When you publish the report to the website, it will be memory and disk space for the Power BI cloud machine.
Power BI leverages the xVelocity compression engine and works on a columnstore in-memory technology. In-memory columnstore technology compresses data and stores it in a compressed format.
When using this method, the size of the model is limited. Your power bi (or file) model cannot exceed 1 GB. Typically, the maximum account capacity is 10 GB, but the maximum capacity per file must be 1 GB. Power BI Premium allows an additional 10 GB.
Best regards
Liang
If this post helps, then consider Accept it as the solution to help other members find it faster.
Hi OZMckenzie ,
The connection to excel can only be in import mode. You can consider using incremental refresh, which will improve the performance of refresh.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
