Following are some better ways in which Excel and Power BI can ensure better cooperation.
Share Excel insights with Power BI Publisher
If you would like to save snapshots of important PivotTables, charts, cell ranges and others from across all of your spreadsheets to a single place quickly, Power BI publisher for Excel offers an option for this. Simply select a range or an element in your workbook and, under the Power BI tab, click Pin. See the screenshot below.
Thereafter, select an existing dashboard from the list or if required, create a new one.
To do so, click the Pin button and you’re done! One feature that should find mention here is that Power BI publisher for Excel also allows you to keep your pinned elements up to date with the Pin manager. However, you need to download Power BI Publisher for Excel to get it started. Download it from here.
Pinning Excel elements to your Power BI dashboard
Upload your Excel reports to Power BI and select a range, a table or a chart. Then, simply click the Pin button and your Excel tile should become a part of your dashboard. In addition to pinning your Excel reports on Power BI, you can also pin content to your dashboards and view spreadsheets when you click the respective tile.
Publish to Power BI from Excel
Publishing your workbook content to Power BI directly from Excel 2016 is as smooth as a breeze. After having your workbook published, you can keep working on it in OneDrive for Business. The good point is, Power BI automatically refreshes when you make updates to your workbook. For publishing your Excel workbook to Power BI, simply select File > Publish.
That’s it!
