Accessing and analyzing Power BI datasets from Excel

With a centralized Power BI dataset in the Power BI Service, Power BI Pro users can take full advantage of Excel's familiar user interface as well as advanced data connection methods such as cube formulas and DAX queries to support custom paginated report layouts. Although these Excel reports, like SSRS paginated reports, are only a supplement to the Power BI reports and dashboards in the Power BI Service, they are often useful for scorecard layouts with custom formatting and many measures and columns. In this scenario, an experienced Excel user with deep business knowledge can leverage the performance, scale, and automatic refresh of the published Power BI dataset to create custom, fully formatted Excel reports. Additionally, the Excel report author has the flexibility to apply report-scoped logic on top of the dataset...