![]() In this tutorial I’ll show you how make an awesome looking map in Excel in under 5 minutes with a free plugin called PowerMap (formerly GeoFlow). Download and install the plugin. Now select Microsoft Power Map and click on OK button to activate it. Power BI publisher for Excel • • 7 minutes to read • Contributors • • • • In this article With Microsoft Power BI publisher for Excel, you can take snapshots of your most important insights in Excel, like PivotTables, charts, and ranges and pin them to dashboards in Power BI. What can you pin? Just about anything in an Excel worksheet. You can select a range of cells from a simple sheet or table, a PivotTable or PivotChart, illustrations and images, text. What you can't pin: you cannot pin 3D Maps or visualizations in Power View sheets. There are also some elements you can pin, but it wouldn't make much sense to, like a Slicer or Timeline filter. When you pin an element from Excel, a new tile is added to a new or existing dashboard in Power BI. The new tile is a snapshot, so it's not dynamic but you can still update it. For example, if you make a change to a PivotTable or chart you've already pinned, the dashboard tile in Power BI isn't updated automatically, but you can still update your pinned elements by using Pin Manager. You'll learn more about Pin Manager in the following sections. Download and install Power BI publisher for Excel is an add-in you can download and install on desktop versions of Microsoft Excel 2007 and later. Once you have the publisher installed, you'll see a new Power BI ribbon in Excel, where you can sign in (or sign out) of Power BI, pin elements to dashboards, and manage elements you've already pinned. The Power BI publisher for Excel add-in is enabled by default, but if for some reason you don't see the Power BI ribbon tab in Excel, you'll need to enable it. Click File > Options > Add-ins > COM Add-ins. Select Microsoft Power BI Publisher for Excel. Pin a range to a dashboard You can select any range of cells from your worksheet, and pin a snapshot of that range to an existing or a new dashboard in Power BI. You can pin the same snapshot to multiple dashboards, too. To begin, you need to make sure you're signed in to Power BI. • Select Profile from the Power BI ribbon tab in Excel. If you're already signed in to Power BI, you'll see a dialog that shows which account you're currently signed in with. If that's the account you want to use, great - go to the next set of steps to pin your range. Select Sign out if you want to use a different Power BI account. If you're not signed in, go to the next step (Step 2). • If you're not signed in, select the Sign In link that appears when you select Profile from the Power BI ribbon tab in Excel, in the Connect to Power BI dialog type in the email address of the Power BI account you want to use, then select Sign In. Once you're signed in, follow these steps to pin a range to a dashboard: • In Excel, select the Power BI ribbon tab to see the Pin ribbon button. • Select a range from your Excel workbook. • Click the Pin button from the Power BI ribbon to show the Pin to dashboard dialog. If you're not already signed into Power BI, you'll be prompted to do so. Select a workspace from the Workspace dropdown list. If you want to pin to your own dashboard, verify My Workspace is selected. If you want to pin to a dashboard in a group workspace, select the group from the drop-down list. • Choose whether you want to pin to an existing dashboard or create a new dashboard. • Click Okay to pin your selection to the dashboard. • In Pin to dashboard, select an existing dashboard in the workspace or create a new one, and then click the Ok button. Pin a Chart to a dashboard Just click on the chart, and then click Pin. Manage pinned elements With Pin Manager, you can update (refresh) a pinned element's associated tile in Power BI. You can also remove the pin between an element you've already pinned to dashboards in Power BI. To update tiles in your dashboard, in Pin Manager select one or more elements and then select Update.
0 Комментарии
Оставить ответ. |
АвторНапишите что-нибудь о себе. Не надо ничего особенного, просто общие данные. Архивы
Март 2019
Категории |