Forum Discussion
Refresh failed only online
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.
Ok I tracked msmdsrv (max while refreshing = 11Go)
and my memory (max while refreshing = 17,6Go)
Here is the problem?
I don't really understand which memory is used when a scheduled refresh is working...
What can I track?
When a scheduled refresh is on, I don't see anything increasing. The memory RAM is still 4Go and no msmdsrv active...
So Anonymous,
The issue here that your report is using11 GB while refreshing. That means you need to buy additional memory (capacity, as I mentioned earlier) and your report will not refresh without it because of a huge amount of data.
If you not willing to do so, you need to optimize your Power BI report data model. Can you share a screenshot of it?
What is my authorised memory capacity? (PowerBI Pro pack) I would know how many data I have to "suppress".
A screenshot of one data model :
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.