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

[TT2542]

Hello everyone,

I am using Power BI with a Pro license and connecting to Oracle. Before this issue occurred, the report was accessible without any problems. However, I recently encountered an error that prevents me from viewing the report at all.

At first, I suspected that the issue might be caused by the dataset exceeding the size limit. However, when I refreshed the data in Power BI Desktop, it worked fine, and the dataset size was within the limit.

Then, I attempted to publish the refreshed report to overwrite the existing one on the Power BI Service, but it failed. Additionally, no matter how many times I tried to refresh it on the Service, the error persisted (as shown in the first image).

Interestingly, this error occurs only with this specific report. As a result, I had to upload it as a new report to make it usable.

Does anyone have any insights into what might be causing this issue? Any help would be greatly appreciated.

[andrewsommer]

I think this is a dataset size issue.  Since you are on pro you are limited to a 1GB dataset.  However, when you refresh or try to overwrite a data set it basically doubles the size because it has to cache the existing one and the new one. 

Download DAX Studio to see what you can get rid of to make your model smaller and more efficient.  Drop unused columns and focus on columns that have a lot of text or high cardinality. 

In settings turn off auto date/time (if you have a lot of date fields in your model this can reduce the size significantly). 

Segregate your reports and models (i.e. use thin reports).     

[v-kpoloju-msft]

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.

[v-kpoloju-msft]

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.

[v-kpoloju-msft]

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.

[Deku]

Limits on desktop side is unlimited. On the service it is limited depending on what capacity you are using.

Chris webb blog gives a good description