Forum Discussion
Choosing the right Power Bi Premium server
Hi all, I need some advices on the right Power Bi Premium server package to choose. I have a huge dataset and I'm afraid the power Bi premium pricing calculator do not reflect my reality. I ...
- Hi there,
It would appear that you should be ok on a P1 with incremental refreshing.
There is a new premium capacity metrics app which can be used once implemented to see how everything is performing.
And as I'm sure you have read before if there is anything to make the model smaller look into that. Like unused columns and removing the built in date columns.
Hi GilbertQ,
thanks for your insights.
The PBIX file is 8Gb.
There is 4 level of security applied using RLS : Salespersons (250), manager (30); director (10) and admin (10)
We plan to use the incremental refreshing functionnality.
Base on this information, have you got any other insights?
thanks,
Joel
GilbertQ
Super User
Super UserHi there,
It would appear that you should be ok on a P1 with incremental refreshing.
There is a new premium capacity metrics app which can be used once implemented to see how everything is performing.
And as I'm sure you have read before if there is anything to make the model smaller look into that. Like unused columns and removing the built in date columns.
It would appear that you should be ok on a P1 with incremental refreshing.
There is a new premium capacity metrics app which can be used once implemented to see how everything is performing.
And as I'm sure you have read before if there is anything to make the model smaller look into that. Like unused columns and removing the built in date columns.
thanks Gilbert,
it is very helpfull. we are in the development phase, I will let you know in this conversation for the final result.
thanks again,
Joel
- GilbertQNo worries, I will be interested to see how it goes.