Forum Discussion
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.
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.
Hi TT2542,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi TT2542,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi TT2542,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.