Reply
bourne2000
Helper V
Helper V
Partially syndicated - Outbound

How to handle the big data in Power BI?

Hi

 

I am having data in MY SQL which comes from a Wearable device. MySQL is hosted on a private cloud and the data size is > 5 Million records.

 

Power BI is very slow in handling the above data. I need your guidance to overcome this problem? Data will keep on increasing every day. Can anyone please advise me of the following?

 

1) Is there any other way available?

2) Can we use Azure? If so what components are to be used?

3) I am building a live dashboard so need an efficient solution to overcome this issue.

 

Please advise

2 REPLIES 2
YukiK
Impactful Individual
Impactful Individual

Syndicated - Outbound

How do you have your data model? Million records shouldn't be an issue at all in Power BI.

 

You want to make sure to model your data with star schema/dimensional model.

Syndicated - Outbound

@YukiK I am not able to build the data model in the Power BI as its very slow when I import the data into Power BI. 

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)