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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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