Azure SQL Datawarehouse + DirectQuery + Power BI = ?

[Anonymous]

Dear Community,
 
I have a question :

In a Big Data Architecture (Data Lake Store), is connecting Power BI to Azure SQL Datawarehouse through DirectQuery not to heavy to support for it ?
It's not going to saturate the dababase ?
 
Thank you for your answers.

[Seth_C_Bauer · Accepted solution]

@Anonymous In my opinion DQ is valueable for extremely large datasets that you can't stick in Azure Analysis Services, if you can - I'd recommend adding the AS layer and having Power BI live connect to that. You'll get much better performance and you won't need to model in the PBI reports. If you are "at scale" where that isn't feasible, you just need to ensure you are tuning your queries in the WH to be as performant as possible because every interaction by a report user will execute a query. So you will need to do some anlysis on expected workload and user base to understand the type of performance/sizing you require for the WH to support internal and external workloads.

[Anonymous]

Thank you for your answer !

So, is AS + LiveConnect a suitable solution for a large company with a lot of users ?

[Seth_C_Bauer]

@Anonymous  Yes, it is from an enterprise reporting standpoint. There are a whole slew of ways in which you can implement solutions, but from an enterprise level AS should be part of your solution to support larger models and needs for enterprise reporting.