where to find data analysis tool in excel 2013

Now click “Sign In” and use your other Power BI service account credentials. If you have different Power BI service account and you’d like to switch between your accounts and analyse the different accounts from Excel just click “Profile” from “Power BI” tab from the Excel ribbon then click “Sign Out”. If you login to your Power BI service you’ll see the sample.If you do not have any data in your Power BI service, the published add-in detects that and offers you to create sample data in Power BI.Now you can analyse the data in Excel without needing to download “odc” connection file like what we used to when we wanted to analyse a report or dataset from Power BI service.Select a workspace, report or dataset then click connect.Enter your email address associated with Power BI service account and click “Sign In” If you haven’t already logged into your Power BI service you will prompt to login.After you install the Power BI Publisher for Excel, click “Connect to Data” from “Power BI” tab from Excel ribbon.With the new Power BI Publisher add-in for Excel we can now easily connect to a Power BI service account and analyse the reports and datasets directly from Excel: Now you can analyse the data in Excel using pivot tables and pivot charts.Īnalyse Power BI Service Reports or Datasets in Excel (Directly From Excel).Doing either way, it downloads an “odc” file that could be opened in Excel.Clicking ellipsis button of a desired report and clicking “Analyse in Excel”.Clicking ellipsis button of a desired dataset and clicking “Analyse in Excel”.Previously we could analyse Power BI data in Excel directly from Power BI service by: Power BI Publisher for Excel add-in will be enabled by default after you install it, however, if you don’t see the “Power BI” tab in the ribbon in Excel you can enable it from File –> Options –> Add-ins –> COM Add-ins –> tick Microsoft Publisher for Excel.Ĭonnect to and Analyse Power BI Data in Excel Analyse Power BI Service Reports or Datasets in Excel (From Power BI Service).Download and install Power BI Publisher for Excel.Desktop versions of Microsoft Excel 2007 and later.Using the new Power BI Publisher for Excel, not only can we pin an Excel range or chart to a Power BI dashboard directly from Excel, but also we are now able to easily connect to a Power BI service, select any group workspaces and analyse a desired report or dataset.

In this post you learn how to analyse Power BI data in Excel. Today I want to explain some new features added to the publisher. A while ago I wrote a blog post about Power BI Publisher for Excel.

Where to find data analysis tool in excel 2013