allow other users to view interactive Dashboards and reports in Office365 on Azure

[Anonymous]

I am creating Power BI Dashboards and reports on my desktop version (Power BI Pro).

we have a database (SQL server) on another Azure instance that holds all the data. The PowerBi reports on my desktop access them via VPN. All is well.

The organisation has Office365 and a handful of users want to see (and manipulate paramaters of) these reports, under MS Active Directory control of course!

Happy to buy each user a desktop PowerBI Pro license if required.

Currently, we need to install the PowerBI reports on the users laptop and then connect them via VPN to the SQL server dB and it's a complicated process. Far better if they can access the reports using PowerBI pro on their machines.

Can anyone please point me in the right direction and get a solution?!!

How do I achieve that without buying the $4995/mo license for premium?

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

If each of the users has a Pro license then you won't need premium service. 

You will want to create a workspace on PowerBI.com to publish company report to.  Once you are done authoring your report you would publish it to the PowerBI service in the company workspace.

Then you can share those reports with the other users in your company, they just need the Pro license to view them.

https://docs.microsoft.com/en-us/power-bi/guided-learning/publishingandsharing