Microsoft Power BI helps organizations empower everyone to make every decision based on data. We are excited to announce that we have Egnyte for Power BI Data Connector in Beta, so power users can connect and get easy access to Egnyte data, and can query shape and select data from multiple files to create dashboards, and reports in Power BI Desktop.

As you publish these reports to Power BI Service,  you will be able to auto-refresh data through Microsoft Gateway and can collaborate with the other users so they can access the latest data. 

Initial Setup:

Prerequisites:

  1. Microsoft Pro or Premium license for both admins, and Users to access the content of the report
  2. Standard on-premises gateway is recommended if you want to collaborate with other users.

Refreshing doesn’t work when the computer on which standard gateway is installed is offline. Link is here - https://powerbi.microsoft.com/en-us/gateway/

Computer Setup: 

  1. If using Personal gateway - Create a "[My Documents]\Power BI Desktop\Custom Connectors" directory AND/OR
  2. If using Standard gateway - Create a "\Windows\ServiceProfiles\PBIEgwService\Documents\Power BI Desktop\Custom Connectors" directory.
  3. Get EgnyteConnector.mez file here and place it in the "Custome Connectors" directory above. 
  4. Open Power BI Desktop if you have it installed. 

Power BI Gateway Setup (For refreshing data): 

An on-premises data gateway (standard gateway) is a software that you install in an on-premises network. The gateway facilitates access to data in that network. You can install a gateway either in personal mode, which applies to Power BI only or in standard mode. We recommend the standard mode.  Note. On a single computer, you can run a single instance of personal and standard gateway both. 

  1. Install On-premise (Standard) and Personal gateway https://powerbi.microsoft.com/en-us/gateway/ and follow the process and Microsoft wizard. 
  2. Login using your admin credentials and Configure and name your Gateway Connection (The user installing the gateway must be the admin of the gateway)
  3. Add gateway admins who can also manage and administer other network requirements.
  4. Use the gateway to refresh an on-premises data source.
  5. Troubleshoot the gateway in case of errors, and make sure it is online.

Power BI Desktop (For Creating reports): 

  1. Go to Windows.
  2. Install Power BI Desktop if you do not have it already.
  3. Login with the same Microsoft credentials where you have a Power BI Pro or Premium license. 
  4. Enable the "(Not recommended) Allow ..." in Power BI Desktop (under File | Options, and settings | Options| Security| Data Extensions) to enable Beta integration. 
  5. Click "get data"
  6. Select the "Egnyte connector (beta)" from the list. 

 

mceclip7.png

 

mceclip0.png

7.  When clicked "Connect" - this will open a dialog and ask you to enter your Egnyte domain. Use Domain in the form here - "https://YOURDOMAIN.egnyte.com" and click OK.

mceclip8.png 

8. Follow the Sign-in process and use your Egnyte credentials to complete the sign-in process.

9. Once you signed-in, you will see the navigator table with your Egnyte files as below. You can select 1 or more files (supported formats are XLS, XLSX, CSV and Text files) 

mceclip14.png

10. Creating visualizations is not part of the integration - at this moment, mangle with the data as per the needs of your organization and create reports.  

11. Save the report/dashboard and create publish. 

 Screenshot__381_.png

 

Power BI Service (for Collaboration): 

  1. Access link which you have been provided in Step 11 and open Power BI Service in your browser. Alternatively, you could also access this report via browser, using the same account login (as used in the desktop app) and look for the published data there. 
  2. Ensure your Gateway is running and is online and connected.  Microsoft guide here
  3. On the machine where the gateway is running, enter gateway in Windows search.
  4. Select the On-premises data gateway app
  5. Log in with Microsoft credentials as used above.
  6. Go to Connectors - and Ensure you have "Egnyte" showing in the dropdown list and select.
  7. Ensure that in the folder settings, you have Egnyteconnector.mez file. If using Personal Gateway OR, if using Standard Gateway (Note the directory structure difference as mentioned in Section A).

 PowerBI-1.png

 

 

mceclip10.png

      8. Go to your dataset on the left-hand side, and click on "scheduled refresh". In this example, we have used the "Life Expectancy" report, which is on the left-hand side, and "scheduled refresh" for illustration. 

mceclip11.png

 

      9. Configure. If you are using a Personal gateway, select that checkbox and Apply.

     10. If you are using Standard Gateway - ensure you select "data sources" and select the dataset you want to refresh for the report/dashboards. See the next 3 screens.    

 a) Configure data source setting, ensure you have valid credentials, and "connection is successful".

mceclip0.png

    b) Ensure the above dataset is connected to the standard gateway you are using as below. PowerBI-2.png

 

 c) Ensure the data source credentials section when you scroll down, and there is no error. 

 

mceclip16.png

 

     11. If you want to apply auto-refresh, please configure. Note. Auto-refresh frequency depends on the type of Power BI license you have from Microsoft - Pro or Premium. 

PowerBI-3.png

  

      12. You can select Refresh History from the top of the screen.

If you are using a personal gateway, then if your computer is offline, the refresh will not succeed.  Additionally, the same thing that refreshes with using a standard gateway will also fail if the server on which it will be installed will be offline so, please do look into that to trouble-shoot if you see that it failed. 

PowerBI-4.png

Remove Authentication for the Egnyte Domain:

Go under Power BI Desktop: File | Options, and settings | Data Source Settings | Clear permissions. 

mceclip1.png

Additional factors and Power BI Knowledgebase

Per Microsoft documentation, you can install up to two gateways on a single computer: one running in personal mode and the other running in standard mode. You can't have more than one gateway running in the same mode on the same computer.

Personal Gateway:  It allows one user to connect to sources, and can’t be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI. This gateway is well-suited to scenarios where you’re the only person who creates reports, and you don't need to share any data sources with others. If you want to install this on your machine, and it is often offline.

Standard Gateway: It allows multiple users to connect to multiple on-premises data sources. You can use an on-premises data gateway with all supported services, with a single gateway installation. This gateway is well-suited to complex scenarios with multiple people accessing multiple data sources. Note. you could use windows server or window machine that works all the time so that gateway is always online. 

Note. During tests, if multiple developers are working on the same MS accounts, it is essential to be sure whose personal gateway is used. If you, for example, create a new version of the connector but it right now is pointing to a different computer with a different version of the connector, then something will go wrong. Always be sure that the gateway is pointing to your machine.  A similar issue is with a standard connector. If you want to use it with your source, be sure that it is using the same connector version so, recommend using the right naming conventions in settings and is online. 

 

Well, done! 

 

Please contact us or your CSM if you are interested in Beta Additionally, we are also interested to get your feedback on what other functionality you would like to see in the future in this thread.