WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 525 reviews for our classroom and online training
Find the many ways to interact directly between Excel and Power BI Service
Part one of a four-part series of blogs

You can pull Excel workbooks (or individual data ranges) into Power BI Service, or push them from Excel using a special add-in. This blog shows how to use both approaches, as well as the underwhelming Analyze in Excel feature.

  1. Working with Excel in Power BI Service (this blog)
  2. Analysing Data with Excel
  3. Getting Data from Excel or CSV files in Power BI Service
  4. Publishing Excel workbooks, or tiling parts of a workbook

This blog is part of a longer series, which together comprise a full online training course in Power BI Service.  You can see get details of our classsrom Power BI training courses here.

Posted by Andy Brown on 29 June 2017

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Working with Excel in Power BI Service

There are many ways in which you can get Excel and your reports to interact!  Here's what this blog covers:

Topic Notes
Analysing data in Excel How to create a pivot table in Excel, based on a report's dataset.
Importing from Excel How to import entire Excel workbooks into Power BI Service, or just their underlying data.
Tiling and publishing from Excel How to publish entire workbooks directly from Excel, or alternatively how to tile individual parts of a workbook.

I'll start with the feature I like least: Analyze in Excel.

This blog has 0 threads Add post