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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
abalgir
Helper I
Helper I

big data analysis : can power BI handles Millions of row in a reasonable duration

Hello, I have been testing Power BI for a possibility of using it with my software instead of tableau, Excel ... or other BI. 

I have a tricky question:

I receive 1 to 5 million of rows of data (around 16 fields each row) per day, and I store incrementaly the result in a postgress on a server on Digital Ocean.

Will Power BI functions on tables with 100s Millions of rows and can i use the web reporting function. I read somewhere that I need to use Azure for Power BI for large volumes ???

 

I need to know if this is feasible first,  then I will surely ask the community how this is done and how I can distribute different reports on the web for different users. This is a big project, and I need you support 😉

 

Thank you for your support

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

By using a Premium capacity, Power BI will handle trillions of rows and petabytes of data. 

 

https://powerbi.microsoft.com/en-us/blog/petabyte-scale-analytics-with-power-bi-and-azure/

https://powerbi.microsoft.com/en-us/blog/aggregations-for-petabyte-scale-bi-available-in-the-power-b...


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

By using a Premium capacity, Power BI will handle trillions of rows and petabytes of data. 

 

https://powerbi.microsoft.com/en-us/blog/petabyte-scale-analytics-with-power-bi-and-azure/

https://powerbi.microsoft.com/en-us/blog/aggregations-for-petabyte-scale-bi-available-in-the-power-b...


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.