Solved: Refresh failed only online - Page 2

Anonymous · ‎04-12-2018

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 memory).

But the message is clear :

"Memory allocation failure. Try simplifying the number of queries"

Which memory? As I said, when I refresh with desktop, it uses 15Go/32Go memory.

Thanks for all of you

zoloturu · ‎04-20-2018

@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.

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).
Reduce the number of rows in a way I told step before (smaller period or any other filters, if possible).
Sometimes better if you will do maximum SQL JOINes on database side then on Power BI side.

View solution in original post

Refresh failed only online

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024