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
Anonymous
Not applicable

Migrate from Custom Analytics to Power BI

Hi,

We have an analytics dashboard customized as per the requirements, in which we are directly accessing the MySQL data and showing the records on the customized UI. Now we are planning to move away from all the custom developed UI to a BI tool. For this we are evaluating different BI tools available in the market e.g. Tableau, Power BI.

We have a relational database with around 6 TB of data and the requirement is to show the statistics using maps, bar graphs etc on the BI tool dashboards.


1) How many users can access the dashboards parallely? Lets say if we share the dashboard with 100+ users, will that be supported?
2) In future if the no of users grow, how can the solution be scaled up e.g. we require mulitple deployments of Power BI servers. If some info on this can be made available that would helpful.
3) Is predictive analysis supported? Lets say for our usecase we are showing events related data and we want some preditictions to be made on the data, does PowerBI tool support it?

 

Also could you share the steps required to migrate from custom analytics to Power BI.

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

1.

Power BI has different liscenses.

With pro/premium liscense, sharing the dashboard with 100+ users is supported.

Please read the following documents to know the difference among these liscenses.

Power BI Licensing Walk-through Guide

Power BI service features by license type

Power BI Pro & Power BI Premium: Flexibility to choose the licensing best for you and your organization

Ways to share your work in Power BI

 

2.

You could buy the liscenses per your requirements month by month, so don't worry about this problem.

 

3.

It is possible.

Data Forecasting and Analytics with Power BI Desktop

Power BI & Azure ML Better Together

Power BI - Predictive Analytics with Forecasts and R Language Libraries

 

Last but not least, It should be noted when you have large data such as 6TB, you should consider "direct query"/"live connection" when connecting data to Power BI.

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

1.

Power BI has different liscenses.

With pro/premium liscense, sharing the dashboard with 100+ users is supported.

Please read the following documents to know the difference among these liscenses.

Power BI Licensing Walk-through Guide

Power BI service features by license type

Power BI Pro & Power BI Premium: Flexibility to choose the licensing best for you and your organization

Ways to share your work in Power BI

 

2.

You could buy the liscenses per your requirements month by month, so don't worry about this problem.

 

3.

It is possible.

Data Forecasting and Analytics with Power BI Desktop

Power BI & Azure ML Better Together

Power BI - Predictive Analytics with Forecasts and R Language Libraries

 

Last but not least, It should be noted when you have large data such as 6TB, you should consider "direct query"/"live connection" when connecting data to Power BI.

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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