topic Re: Performance difference between PowerBI Report Server and PowerBI Service on huge set of data in Report Server

Performance difference between PowerBI Report Server and PowerBI Service on huge set of data

Anonymous — Mon, 20 Jul 2020 20:15:06 GMT

I am designing the solution for my client. Some Dataset size are between 8 to 10 gb and other dataset sizes are more than 10 gb.

My client is willing to go for Power BI Report Server for deployment .

Can you please someone suggest the performance difference between PowerBI Report Server and PowerBI Service on above set of data.

Regards

Sukesh

Re: Performance difference between PowerBI Report Server and PowerBI Service on huge set of data

Greg_Deckler — Mon, 20 Jul 2020 20:29:10 GMT

Anonymous - Are you going to use Premium?

Re: Performance difference between PowerBI Report Server and PowerBI Service on huge set of data

KBO — Tue, 21 Jul 2020 06:20:22 GMT

Hi Anonymous ,

If you like to work with a higher amount of data I would prefer to use a SSAS solution, that is very common in Power BI On Premises. If you like to use the same amount of data in the Power BI Service I think you need a bigger capacitiy like Greg_Deckler mentioned you will need premium capacity to get a better performance. But you can also consider to use SSAS in the Power BI Service.

For more information about SSAS you can follow the link - https://blog.pragmaticworks.com/choosing-to-model-in-power-bi-vs-ssas-tabular

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Re: Performance difference between PowerBI Report Server and PowerBI Service on huge set of data

Anonymous — Tue, 21 Jul 2020 12:54:40 GMT

Greg_Deckler Yes. I have plan to use Premium.