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 V-lianl-msft
I have one further question regaring the incremental refresh, my data source are mostly Excel file, however I read from somewhere that Excel doesn't support the incremental refresh.
The major data source is loaded from SAP and export to Excel, refresh daily. The rest are Excel Queries that I created to gather data from multiple sheets. Does the incremental refresh work on these kind of file?
Could you please advise? Thank you so much.