Differences Power BI Pro, Premium, Report Server, Service
I'm a software developer and have a request from a client to use Power BI. The desire is to have a COMPLETELY cloud-hosted solution. So the user should be able to use their web browser to access a Power BI GUI from which they can build, view, and share visualizations and dashboards. Their data is housed in the cloud in Azure SQL Warehouse. Power BI needs to be hosted within the same Azure environment as their database.
I feel like I'm reading myself into circles trying to figure out if Power BI has this capability. Can someone point me in the right direction and maybe provide some technical documentation on the topic? I'm looking from insight from another developer.
The best I can tell, this is NOT possible? There is no Azure-managed Power BI service. Rather, the workflow would be to produce dashboards in Power BI Desktop and publish them to the cloud? If that's the case, then is Power BI Pro or Premium even hosted in your environment? If so, how is it deployed? I can't find any information on this. Thanks!
Posted Apr 25, 2019, 7:18 PM UTC · edited
I don't have all the answers, but am a developer that has worked on similar things.
The client is probably using Office 365. Each office 365 user in an Office 365 Tenant has a Microsoft Account. This same account can also be used on PowerBI.com and is connected to their Office 365. In fact, it's from the Office 365 Admin Portal (usually) that you buy and assign Power BI licenses if needed.
When you open Power BI Desktop and log in with your Microsoft account you gain the ability to publish a report or dashboard to PowerBI.com. Note that you don't have to log in, but you can't use any of the cloud features.
After you log in to Power BI Desktop you add a Data Source. That data source can be Azure SQL like in your case. The credentials for that Azure SQL server (best practice says use RBAC and read-only) are embedded into the Power BI data source and file or the user can use OAuth.
It's like using any other SQL server. The Azure SQL server needs to be configured to allow connections from other Azure services as described here.
Once the reports are published to the user's Power BI account, you now have to keep the data updated and share the reports with others. That's where the license and some additional config come in.
You'll need to set up data refresh as described here. See the "Databases in the cloud" section. Some good news with Azure SQL is you don't need a gateway which is another thing to maintain.
Finally, for other users to see the published reports they'll need a Power BI license. Pro vs. Premium depends on your use case. But a license is required to view online reports afaik. This is a good read and quick read on it. I'd star with one Premium license to try things out.
As a side note, an Azure Tenant is separate from but can be connected via sharing a directory to an Office 365 Tenant. I don't think there's too much to worry about there in your case.
It's possible I've missed something but just trying to point you in the right direction. Good luck and sorry for the wall of text!
Thanks this is very helpful! I think what is confusing is that Microsoft is calling it Power BI service, but the actual business intelligence where you build a dashboard is still local. The cloud services are just authentication and publishing to a cloud store. Would you say that’s correct?
Yes, at a high level that's right. I would add that they also cache your data in the Power BI service (if you're not using direct query).