televur.blogg.se

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.