We can also create a new dashboard from Excel (I created a new dashboard in my example):ģ. We are then faced with a dialog box to select which dashboard we want to pin the chart or range to. To pin a visual simply select the range or the chart, right-click and hit “Pin to Power BI dashboard”:Ģ.That means that we are able to report on data without having to connect to a source (OLAP cube, SQL database e.g.). So what are the available options in this add-in? We can pin our charts, Pivot Tables and cell ranges, but we can also connect to existing datasets already published to Power BI.com which is pretty cool. So click the profile button on the ribbon and sign in. First of all, we have to sign into our Power BI account. Ok, so we should now have our Power BI tab ready. You should now see the new Power BI tab on the ribbon menu.
Tick the checkbox for Power BI Publisher and hit OK.
#Bi publisher excel template pivot windows#
Follow this step by step guide to activate the Add-in:Ģ.On the Excel Options windows go to “Add-ins” and under “Manage” select “COM Add-ins”, and hit “Go…”ģ. If not, then you have to active the COM add-in from the Add-in menu under options.
0 kommentar(er)
