Enable compatibility with Excel
Using Microsoft Power BI is beneficial in situations when data exploration is best performed by using the interactive visual experience. Occasionally, you might want to explore your data by using PivotTables in Microsoft Excel.
The Microsoft Power BI suite of tools helps give organizations the freedom to use their analysis tool of choice when it comes to analyzing information in the dataset. Not every user has Power BI and Data Analysis Expressions (DAX) experience, and users might not want to learn a new tool.
Excel is still the most widely used analysis tool in the world, and it's the foundation for analytics for most departments. Microsoft recognizes the need to connect the new tools to that foundation. Allowing users to connect to your dataset in Excel will lead to better adoption and greater alignment to a single version of the truth when everyone is using the same dataset to answer questions related to that part of the business.