cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
abalgir Regular Visitor
Regular Visitor

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

Accepted Solutions
Super User
Super User

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

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...


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

1 REPLY 1
Super User
Super User

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

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...


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 46 members 853 guests
Please welcome our newest community members: