After setting up the Power BI Custom Connector and building the visual reports, you might consider customizing the automated data update to always stay up to date with a fresh scope of analytics.


To make the customization, please consider these several steps below:


Step 1. Install On-premises Data Gateway


The On-premises data gateway acts as a bridge, providing quick and secure data transfer between data that is in your Power BI Desktop application and the Power BI online (app.powerbi.com). Hence, when you build reports in Power BI Desktop that use Precoro Power BI Custom Connector, you can use the On-premises data gateway to publish and refresh those reports from the Power BI Service.


Go to app.powerbi.com, use Settings → Download Data Gateway:



A download page for the Data Gateway will open. Choose your Gateway type and click on the appropriate button to download the setup file.


You can use an On-premises Data Gateway in standard OR in personal mode. There are some differences between these types of Gateways. It's recommended to use the standard one (also known as Enterprise). 
However, feel free to choose the option which is more suitable for you.



Step 2. Configure the Data Gateway


For both types of Gateways:

  • Once it is downloaded, please open the file as an administrator and install it.
  • Then, Sigh In by providing the email address you use to log in to the Power BI Service. 


Please note that this user must have administrative rights in the Power BI service workspace.



The standard Gateway type may require you to configure a new gateway at this step. Just click Configure, choose "Register a new gateway on this computer," then provide Name (for ex., Precoro API) and create a Recovery key.

Note: The recovery key is a password used to restore the gateway.

  • Now that the Gateway is installed and ready for use. You should see the appropriate message in the Status tab.



  • Go to the Connectors tab and check if the Precoro API connector is in the list. If not — check the provided path and change it to the one where your connector is placed. In the end, you should see the Precoro API connector in the list.


Only for standard Gateway type: make sure your folder can be accessed by the user running the gateway service, which is NT SERVICE\PBIEgwService by default. Note that when adding or changing a connector, you must restart the On-Premises Data Gateway.


Please note that it may take a few seconds for the Precoro API connector to show up in the list.



Step 3. Publish your report and configure the data connection


After finishing building your report in Power BI Desktop, use Publish button at the top ribbon.


 

Then, go to app.powerbi.com, find the Dataset for your report, and select More Options (...)Settings next to a dataset listed:



If you are a multi-companies or multi-accounts user in Precoro, refer to the article Specifics of Using Precoro Power BI Connector for Multi-companies by passing this step.


Option 1. On-premises Data Gateway (standard mode)


Skip and move to option two if you're using the personal mode of Date Gateway.


In the Gateway connection section, find your "Precoro API" option (or whatever you named it). There will be a message "Not configured correctly." So, it's time to configure it.

Click on the Manage Gateways icon:



In the window that appeared, tick the option "Allow user's custom data connectors to refresh through this gateway cluster," and click Apply.


Please note that this window may look differently in your Power BI. However, the list of settings and options should be the same.



Then return to the Dataset settings. Next, click on the "Manually add to gateway" link:



In the opened window, configure a New data source. Select a name (any) and fill up your credentials (email and API token you used when logged in to the connector):




Now return to the Dataset settings and map your new data source. Click Apply.



After, you should see the success message at the right top of the screen:


Done! Now you're able to set up a scheduled refresh.


Option 2. On-premises Data Gateway (personal mode)


In the Gateway connection section, find your "Personal Gateway" option, select it and ensure it's running (has a green status). 

Then, go to the Data source credentials section and click on "Edit credentials":



In the popped-up window, input your email and API token you used when logged in to the connector. Then, press "Sign in":



After, you should see the success message at the right top of the screen:



Done! Now you're able to set up a scheduled refresh.



Step 4. Set up scheduled refresh


Then, go to the Scheduled refresh section, set the toggle button to the "On" mode, and adjust the frequency, time, and other parameters of data update depending on your needs. Then, click "Apply":



That's it! You're all set!

Now you'll see your next scheduled refresh in the column "Next refresh" against your Dataset: