Power Bi App resource

[jwo]

Hi,

Context: I share a report from my workspace to a premium workspace app. The dataset is hosted in my workspace.

Then, I publish the report through my premium workspace app to other users. 

When the other users interact with the report, would the resource capacity be impacted on the premium workspace or my workspace?

[jwo]

@Greg_Deckler , Yeah, it is a direct query connection to a dataset in my workspace.

[Greg_Deckler]

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

[jwo]

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

[Greg_Deckler · Accepted solution]

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

[Greg_Deckler]

@jwo So the report has a live or DirectQuery connection to a dataset in your My Workspace?