cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
abalgir Frequent Visitor
Frequent 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...


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

Proud to be a Datanaut!


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


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

Proud to be a Datanaut!