Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Refresh failed only online

Hi everyone, I got a problem with the scheduled refresh online. Severals reports can't be refresh online. The other ones are ok. No problem with desktop to refresh all of ones (use max 15Go/32Go m...
Need Help
  • zoloturu's avatar
    zoloturu
    8 years ago

    Anonymous,

     

    There is no fixed capacity per Pro user. That's why it is called SHARED. It depends on how much users are using Power BI Service with shared capacity. 

     

    As per my feeling usually, it is around 3-5 GB.

     

    1. Remove not used columns in data load. It means if you want to load Clients table, then prepare view/table on database side with needed fields. (Or while connecting to DB write SQL script where choose required columns).
    2. Reduce the number of rows in a way I told step before (smaller period or any other filters, if possible).
    3. Sometimes better if you will do maximum SQL JOINes on database side then on Power BI side.

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I got this message :

 

Connected with gateway (not personal mode) and no pb with id informations. The datas come from Dynamics NAV. And I got no pb when I refresh the report with PBI Desktop! (use 15Go/32Go of memory system)

As I said, I got no pb with the others reports (same gateway, same db...).

 

I don't really understand what you need to know.

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

I think your issue may related to refresh data limit, please cut down your data amount and try again.

 

For detail information, please refer to following link:

Troubleshooting Uncompressed data limits for refresh

Uncompressed data limits for refresh

The maximum size for datasets imported into the Power BI service is 1 GB. These datasets are heavily compressed to ensure high performance. In addition, in shared capacity, the service places a limit on the amount of uncompressed data that is processed during refresh to 10 GB. This limit accounts for the compression, and therefore is much higher than 1 GB. Datasets in Power BI Premium are not subject to this limit. If refresh in the Power BI service fails for this reason, please reduce the amount of data being imported to Power BI and try again.

 

Regards,

Xiaoxin Sheng