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.
Hi Anonymous,
As I understood you work on included shared capacity. If you have such issue with memory you have only three options:
- Decrease datasets inside your PBIX file and republish it to cloud (rewrite your SQL/MDX and M queries to select only required information in an optimal way)
- To buy Power BI Embedded capacity (go to the Azure portal and get it there, details see here PBI Embedded pricing)
- And more advanced capacity - Power BI Premium (you can buy it on the Office 365 portal, details - PBI Premium pricing)
We have PBI Pro pack (not premium) and 10Go.
I see it seems we use only 825Mo. So, no dataset exceeds 1Go, right?
Where is the "memory pb"? I don't understand
Anonymous,
Power BI Desktop mainly consists of two applications:
- Power BI Desktop (UI and back-end)
- MS SQL Server Analysis Services
Main calculations are done by the second one.
You can check memory RAM using Windows task manager and Resource Monitor by tracking msmdsrv.exe:
msmdsrv.exe
msmdsrv 2
If PBIX file size is 300MB. The same size it will have in Power BI Service (what we can see in your screenshot). But it is just compressed size. When you do refresh the report then it can take up to 20GB for instance. In that case, it is using RAM. When you have just Power BI Free/Pro without Embedded/Premium capacity then you use capacity shared with all other users.
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...