How to set up the PowerOffice GO Power BI Connector
In this blog we will show you, how to set up the Power BI connector.
Setup Microsoft Power BI
In order to install Power BI, please follow the instructions on the official Microsoft page.
After getting the Power BI Connector file, run it and then click Install:
After the PowerOfficeGO Connector is successfully installed on your system you should see the following message:
You can check PowerOffice PowerBI Connector’s location on your device as in the following picture:
The file PowerOffice.mez should be in the folder Documents > Power BI Desktop > Custom Connectors.
Configure Power BI Desktop
When you open the Power BI desktop application, you will see the following screen:
To get to the main screen of the Power BI application you can close the upper window by clicking the X button on the upper right corner of the window. Then, this message will appear:
Click OK and you will see the main screen of the Power BI application as follows:
The next step is to open File->Options and settings->Options:
After that, you will see the following window, where you should click the Security tab on the left side and then check Not recommended option on the right side under the Data Extensions title:
Configure PowerOffice Credentials
The next step is to click on the Get Data icon , on the main window of the application:
The following window will be opened where you should write PowerQuery on the search bar, select it and then click the Connect button which is on the down side of the window:
Next, you open the File tab again ,on the upper-left part of the main screen and click Options and settings, then click Data source settings and a sign in window will appear:
After selecting Power Office GO Connector, the following screen will show:
Write your credentials in this window and click Logg inn. Then in the following window choose your company and then click Continue.
Then, the following window appears where you should click Connect:
Finally, you will see a Loading window, then your tables will appear on the main screen of the Power BI application: