Forum Discussion
Power Bi vs. Data Warehouse
- 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.
Hi ammartino44,
Power BI is cloud-based business analytics service that enables anyone to visualize and analyze data. In my opinion, the ultimate goal of Power BI is to visualize data. It's not a full replacement of data warehouse. But Power BI desktop also provide features for us to model and shape data:
By the way, the big difference between DirectQuery and Import mode is no data is imported or copied into Power BI Desktop in DirectQuery mode. For more information, please refer to this article: Use DirectQuery in Power BI Desktop.
Best Regards,
Qiuyun Yu
ammartino44 You shouldn't compare power bi and data warehouse. Data warehouse is an enterprise need that will store current and historical data for the enterprise while power bi is a visualisation tool. You use power bi for visualising, analysing your data and share it with business users.
ankitpatira. We use Pentaho (have you heard of it?) I believe it is the tool ON TOP of our data warehouse, but it is not very good in terms of analysis and vizualisation. Would you ever put power BI on top of the data warehouse instead? Not really sure how that works.....Also, everyone touts the memory of power pivot and power bi, but almost everything that is output from a data warehouse is at the summary level, so the need for visualization tools is somewhat muted.
- 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.