Unable to View Report, Refresh Model, or Overwrite Report on Power BI Service

Hi TT2542,

Thanks for reaching out to the Microsoft fabric community forum. Thank you Deku, for your input on this issue.

After thoroughly reviewing the details you provided, I have identified few workarounds that may help resolve the issue. Please follow these steps:

The error indicates that your Power BI dataset exceeds the maximum size limit for Power BI Pro. Your dataset size is 2.16 GB (2,158,676,099 bytes). Power BI Pro has a maximum dataset size limit of 1 GB (1,073,741,824 bytes). This causes the "Cannot load model" error.

Remove unnecessary columns and tables in Power BI Desktop using Power Query Editor. Apply transformations like filtering out old data. Use aggregations instead of detailed data and consider pre-aggregated views in Oracle. Enable incremental refresh in Modelling → Incremental Refresh to reduce data load.

If Oracle does not have credentials, navigate to Settings > Datasets > Data Source Credentials. Confirm that the credentials for Oracle are accurate and current. If using SSO or database authentication, ensure that permissions are properly set.

Use Direct Query Instead of Import Mode, direct Query does not load data into Power BI, thereby bypassing the dataset size limit. To switch to Direct Query, navigate to Power BI Desktop → Transform Data → Data Source Settings. Select your Oracle connection and change it to Direct Query. Then, publish the report again.

Power BI Premium Per User supports datasets up to 100 GB. If your organization utilizes Premium Capacity (P1 or higher), the dataset size can be significantly larger. It is advisable to test in Power BI Desktop before publishing to prevent any size-related issues. Please consider deleting the old report and dataset (if historical data is not required) and then re-publishing.

Kindly refer the below following link for better understanding:
Troubleshoot Power BI Desktop publishing - Power BI | Microsoft Learn
Troubleshoot refresh scenarios - Power BI | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.