topic Re: Powerbi with 5tb database in Report Server

Powerbi with 5tb database

MarceloPereira — Mon, 23 Dec 2019 13:23:41 GMT

Hi everyone.

I have a customer that has a 5tb database and I need to do a PoC to demonstrate the PowerBI Report Server.

I am thinking use the SSIS and SSAS to work with this data. My question is: The SSAS live conenection will give me a good performance? There is another possibility for this scenario?

Best regards,

Marcelo.

Re: Powerbi with 5tb database

Greg_Deckler — Mon, 23 Dec 2019 13:31:53 GMT

You could do DirectQuery and if you have Premium you could use Aggregations:

https://docs.microsoft.com/en-us/power-bi/desktop-aggregations

That is how Microsoft demo's petabyte scale databases.

Re: Powerbi with 5tb database

MarceloPereira — Mon, 23 Dec 2019 14:15:34 GMT

Hi Greg_Deckler,

Thanks so much.

When you say DirecQuery you are talking about this function with SSAS, right?

And about the Premium version, I have the Aggregations in On-premise version (SQL Server Licensing)?

thanks