How to Setup up a Power BI Custom Connector for UiPath Data Service?

News Knowledge Base
1

How to Set-up up a Power BI Custom Connector for UiPath Data Service?

Resolution/ Action Plan:

  1. First, Create an UiPath External Application
    1. For this, navigate to the UiPath Automation Cloud where it is required to create an External Application. To do that, go to the ‘Admin’ tab and navigate to ‘External Applications’.
    2. Click ‘Add Application’ and insert the following information:

  1. Now, Configure the security settings in Power BI:
  1. When Power BI Desktop is opened, it may be prompted to update the security settings before using the custom connector.

  1. To do this, go to File > Options > Security > Web Preview Level > Data Extensions. Check the ‘Allow any extension to load without validation or warning’ option and restart Power BI Desktop.To do this, go to File > Options > Security > Web Preview Level > Data Extensions. Check the ‘Allow any extension to load without validation or warning’ option and restart Power BI Desktop.



Pulling the UiPath Data Service Data into Power BI:

  1. Select ‘Get Data’. Search for the ‘UiPath Data Service’ data source, which should appear as a custom connector:

  1. There will be a prompt to provide the organization name, the tenant name and the client ID (app ID of the external app created in UiPath Automation Cloud):

  1. Select the entities to use as data sources from UiPath Data Service:

  1. Now go on to create cool visualizations from the data in Power BI:

Contact UiPath Product Support: If issue persists, create UiPath Support Ticket for further troubleshooting.

Ensure to provide / attach the below list of details in ticket being created,

  1. Confirm if there is a Proxy
  2. Are there any firewall rules that are getting block - check with your IT.
  3. If using On_Premise Setup, from the same machine, please share us the event viewer logs: ETVX Logs .
2

Hello,

When trying to UiPath Data Service Data into Power BI I don’t get any custom connector searching for UiPath.

Do you know to fix this ?