Upload Export Workbook To Microsoft Power BI

I have mentioned and described in a previous post of mine about Microsoft Power BI. Well now, we have two new commands for us available to use so we can Export or Publish our Workbooks to Microsoft Power BI. Let’s just refresh our memory about Microsoft Power BI.

What is it? It is a data visualization and business analytics platform that is suitable for business. It is a collection of online services and features that enable us to find and visualize data, share discoveries, and collaborate in intuitive new ways.

What does it do? Monitors organizational data that is important.

We have tools, so we can quickly Analyze, Transform and Visualize data, and also
Share Reports.  Just keep on reading to find out about the new commands available, or follow the above link to find out what Microsoft Power BI actually does.

Upload - Export Workbook To Power BI

We must select the File tab to move to Backstage View as shown in the image below. Once in Backstage View, from the drop-down menu at the left of the left we select the category Publish as shown below.

File - Backstage View - Publish

Once we select the Publish category, in the middle and under notice we can see the command Publish to Power BI.

Publish To Power BI

At the right and under Publish To Power BI, we are informed with the following: Use Power BI To Create And Share Rich Visual Reports And Dashboards From Your Workbook.

We can also Use Another Account, by selecting the appropriate link

We can also Select Where We Would Like To Publish To In Power BI. If we want to change the location of the folder, we select the drop-down menu in order to change it.

Publish To Power BI

At the bottom of the Publish To Power BI menu, we have located the following to areas with the following commands:

Upload Your Workbook To Power BI

  • Interact With Your Excel Workbook Just As You Would In Excel Online
  • Pin Selections From Your Workbook To Power BI Dashboards
  • Share Your Workbook Or Selected Elements Through Power BI

All we need to do is to press the Upload button at the left of this area as shown in the image below.

Upload Workbook To Power BI

Export Workbook To Power BI

  • Export Table Data And Data Model Into A Power BI Dataset
  • Create Power BI Reports And Dashboards From Your Dataset

All we need to do is to press the Export button at the left of this area as shown in the image below.

Export Workbook Data To Power BI

The steps that we follow have been described in a previous post of mine that I have mentioned above. We must first log in to our account and then follow the steps.

Below you can check out the video describing the procedure of how to Export Upload a Workbook in Microsoft Power BI.

Don’t Forget To Subscribe To My YouTube Channel

YouTube Channel

Advertisements

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on March 5, 2018, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Upload Export Workbook To Microsoft Power BI.

Comments are closed.