Forum Discussion

ammartino44's avatar
ammartino44
Helper III
9 years ago
Solved

Power Bi vs. Data Warehouse

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 replace...
Need Help
  • ankitpatira's avatar
    ankitpatira
    9 years ago
    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.
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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:

     

    Modeling

    Power BI for Data Modelling

     

     

    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

Quentin's avatar
Quentin
Helper IV
5 years ago

Seems to me that the new Composite model feature and the previously available dataflows kills the adventages a datawarehouse could have against powerbi cloud service...

Well done microsoft you truely killed a monster in my understanding