How ready is Power BI for enterprise deployment?

• We currently serve 1,200 users across many different US locations.  We have a use case for adding 500 more users who do not need deep analytic capabilities but do need the dashboard format and the ability to drill down into data.

>>At Microsoft we have 38,000 people actively using Power BI. 

• The data contains PHI so reporting must be able to use our Active Directory security which restrics access by role and and location.

Power Bi can definitely manage this but you need to remember; security is not just tools

For more information please review the Power BI security whitepaper, please download the Power BI Security whitepaper.

• SQL and all reporting tools are currently on-site.  We are interested in moving some functions to Azure but aren't there yet.

Power BI enable you to choose were your data is located, while this is covered in the security whitepapger you will also want to look at the documentation around the gateway: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem