Power Bi vs. Data Warehouse

[ammartino44]

Hello. Everyone says that a data warehouse and Power Bi are complementary and that the better you get with Bi the more a data warehouse can be put to good use. I almost see that Power BI is a replacement for a data warehouse, no? If you have databases with the data, can't you just get the queries that you need from those database directly into power BI?  I guess the only issue would be the amount of data that you can work with is more in a data warehouse tool (Pentaho). Even the creation of metrics is much more flexible in power bi. In our data warehouse, a lot of the output is at the summary level. I guess we can adapt the warehouse but every iteration seems to take a lot of time. Thoughts? 

[ankitpatira · Accepted solution]

@ammartino44 we're doing exactly that using power bi on top of data warehouse. Good thing is power bi has ability of DirectQuery feature which means power bi connects live to your data source and doesn't import any data from the warehouse as data warehouse has millions of rows of records. I would suggest you use DQ feature of power bi and connect straight to data warehouse and that would also eliminate your problem of memory issues.