Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
zubair
New Member

New to Power Bi. Confusing with our setup, suggestions needed.

Hi everyone,


I'm new to Power Bi, and have only tested the free version to see if it was something for us. T
he product looks very exciting and I would like your help to understand how the setup can be implemented correct in my organization. To be clear, im not that interested in the cloud services, since our data (as everyones) is very strictly classified.

About us: Today we have 4 different data sources, each of which has its own SQL database, and on each server as well. They are all  independent from each other. All 4 data sources are physically on our network, and can only be accessed by one on the internal network. We are about 10 super users, and in addition, 50 ordinary users.

The 10 of us would like to be the ones to make data sets, reports, dashboards etc. and publish it out to the rest team so they can see it on their dashboards, or see the reporst etc.
The 4 data souces are updated severel times during the day, and the interval would aprox. be every 1 hour.
The 50 users should see these data sets, reports and thus make their own either from scratch or by continuing to work with them we have created to them.

Could the following setup be a solution to the above:
a) Install a new "central" SQL database server where all data from the four data sources will be replicated into the "central" sql database  either via WebServices, .csv file etc. transfer with sftp for example.
b) On this "central" SQL database, install Power BI Enterprise bridge, and set it up.
c) Install Power BI desktop pro at the 10 super users local machine, and get them connected to the Power BI bridge.
d) Install Power BI desktop on the other 50 users local machine, and get them connected to the Power BI bridge.

Would the above setup work?
Will the price be, 10xsuper users power bi desktop pro? Or would it cost me total 60 Power Bi pro license? Or would these 50 users be free?

In addition, of course license to the central MS SQL database server, plus O.S etc.

Thanks!

1 ACCEPTED SOLUTION

@zubair No, not to my knowledge. Couple other things (GA, General Availability) for SQL 2016 is June 1st, I am not aware of any restrictions on data sources, so using SSAS as a datasource - a PBI Desktop file to create reports and "sharing" that in you SSRS portal should most definetely be a valid scenerio.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

12 REPLIES 12

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors