Power BI Publishing

MarkHansen

I assume you have on-premise data source hosted behind your company firewall. No matter which user sign in Power BI, for Power BI Service, it will use the account you configred in Gateway to access the data source. If you need each user can only view their own data, you can configure row level security.

When you buy license for your organization, each account will have a space which is hosted on a Power BI Cloud Cluster. There's no shared space for entire organization level. To have your dashboard viewed by entire organization, you can create a content pack share publish to entire organization.

Regards,

You asked a very complex question, believe it or not. And there's multiple answers to your question, honestly.

First, the data can be stored directly in the cloud or it could not be. It all depends on how you build the report. There are two basic ways to build a report/dashboard. One way is to import the data directly into a .pbix file on Power BI desktop where you would create your data model from scratch. Once you've created your data model and report, you would then upload this to the Power BI Service. This new data model would have all the data with it. So in this scenario, not only would the visualizations be on the service but the actual data behind it. To give a little history, this could be called the "excel method." This is the only way to build a report using power pivot in Excel. So if you're an OG like me (:-) this is what I'm most comfortable with.

The other way to build a report is via a live connection or direct query. In this scenario, you do not import anything. Instead, you tap into the live dataset (whether that's a cube on SSAS or Oracle DB, etc). When you build a dashboard/report this way, none of the data is physically with the file. So the end user, when they are interacting with the file, is actually sending queries back to the on-premises data source. This option also requires an enterprise gateway in order to handle the security between PBI and the on-premises data source.

I hope that helps.