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

abalgir — Fri, 15 Feb 2019 15:23:09 GMT

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

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

Greg_Deckler — Fri, 15 Feb 2019 18:52:21 GMT

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-bi-service/

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

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

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