Forum Discussion
Power Bi App resource
jwo Non-Premium workspaces run in shared capacity. So, there's only a limited amount of resources available in shared capacity and probably even less resources for stuff like My Workspace versus Pro Workspaces. So, if lots of people get on the Service in the same Azure data center that your Power BI tenant is provised then its going to tax the shared resource capacity and things could get slow, even slower than usual for DirectQuery. A Premium workspace may have limited memory, etc. but it is optimized for enterprise workloads and you and only your users can access and use the capacity of your Premium capacities. So, you can't be affected by everyone else using Power BI if your reports and datasets live in the Premium capacity. That is not true if you leave your dataset in My Workspace. Honestly, I'm very surprised it works at all.
jwo That's a weird use case. So then the query load is going to go against your none Premium my workspace which means you may be subject to noisy neighbor type stuff. I would highly recommend publishing your dataset along with your report to the Premium workspace. My workspace should never be used for production reports.
Greg_Deckler The issue I am facing is the report I created requires a lot of resources and thinking of a way to bypass taxing the premium workspace resources as the users of the report is limited to a few people.
May I know what kind of noisy neigbour type stuff are you referring?
jwo Non-Premium workspaces run in shared capacity. So, there's only a limited amount of resources available in shared capacity and probably even less resources for stuff like My Workspace versus Pro Workspaces. So, if lots of people get on the Service in the same Azure data center that your Power BI tenant is provised then its going to tax the shared resource capacity and things could get slow, even slower than usual for DirectQuery. A Premium workspace may have limited memory, etc. but it is optimized for enterprise workloads and you and only your users can access and use the capacity of your Premium capacities. So, you can't be affected by everyone else using Power BI if your reports and datasets live in the Premium capacity. That is not true if you leave your dataset in My Workspace. Honestly, I'm very surprised it works at all.