Integrate Power BI

June 4, 2020

Contributed by:
PC

Integrate with Power BI to receive automated notifications for important reporting changes in Citrix Workspace.

Use the following process to enable the Power BI Integration. Ensure you meet the prerequisites and provide connection details. After you complete this process, your existing level of audit logging persists, including any actions carried out by the use of Citrix Microapps.

An account that has permissions to create an app registration in Azure AD. This account might be problematic depending on which subscription/tenant it associates with first.

A service account that is used to authenticate the integration.

These prerequisites assume you administer the Power BI instance of your organization to set up the integration. The service account must have the following API Permissions assigned with Type: Delegated:

Group

API/Permissions name

Type

Description

Azure Active Directory Graph (1)

User.Read

Delegated

Sign in and read user profile.

Power BI Service (18)

App.Read.All

Delegated

View all Power BI apps.

Capacity.Read.All

Delegated

View all capacities.

Dashboard.Read.All

Delegated

View all dashboards.

Dataflow.Read.All

Delegated

View all dataflows.

Dataset.Read.All

Delegated

View all datasets.

Gateway.Read.All

Delegated

View all gateways.

Report.Read.All

Delegated

View all reports.

StorageAccount.Read.All

Delegated

View all storage accounts.

Workspace.Read.All

Delegated

View all workspaces

After you set up this integration in Power BI, you will need these artifacts to add the integration in Citrix Workspace Microapps:

Client ID

Client Secret

OAuth Authorization

Register your application

Navigate to https://dev.powerbi.com/apps, and register your application with Azure AD to allow your application to access the Power BI REST APIs and to set resource permissions for your application. Through this registration process, you create your Client ID and Client Secret.

The first callback that is listed does not change. The second callback depends on the target application, and can be found in your URL address bar when creating the integration. The section {yourmicroappserverurl} is composed of a tenant part, a region part, and an environment part: https://{tenantID}.{region(us/eu/ap-s)}.iws.cloud.com.

Enter a name for your application.

Select Server-side web application.

Enter your application’s Home Page URL.

Enter the following Redirect URLs:
https://{yourmicroappserverurl}/app/api/auth/serviceAction/callbackhttps://{yourmicroappserverurl}/admin/api/external-services/com.sapho.services.powerbi.PowerBiService/auth/serverContext

Note:

It has been reported that for some users two URLs are not permitted in this field. In this case, go to Azure AD App Registration to add the second URL.

Select all read only APIs check boxes.

Select Register.

Add the integration to Citrix Workspace Microapps

Add the Power BI integration to Citrix Workspace Microapps to connect to your application. This delivers out-of-the-box microapps with pre-configured notifications and actions which are ready to use within your Workspace.

Follow these steps:

From the overview page, select Get Started.

The Manage Integrations page opens.

Select Add New Integration, and Add a new integration from Citrix-provided templates.

Choose the Power BI tile.

Enter a name for the integration.

Enter the Connector parameters that you collected in the previous procedures.

Enter your Client ID and Client Secret.

Enter you Office 365 Tenant ID.

Select Log in with your Power BI account to enable OAuth Authorization. A Power BI sign-in page opens in a new tab. You are prompted to enter an account name, enter a password, and accept requested permissions.

Select Add.

The Microapp Integrations page opens with your added integration and its microapps. From here you can add another integration, continue setting up your out-of-the-box microapps, or create a new microapp for this integration.

Use Power BI microapps

Existing Web/SaaS integrations come with out-of-the-box microapps. Start with these microapps and customize them for your needs.

Our Power BI integration comes with the following preconfigured out-of-the-box microapps:

Dashboards: View details of Power BI dashboards.

Notification or Page

Use-case workflows

Dashboards page

Provides a list of available dashboards with a link to a page with details.

Dashboards Detail page

Provides a read only detailed view of a dashboard with a link to the target source of record for a more detailed view.

Reports: View details of Power BI reports.

Notification or Page

Use-case workflows

New Report Added notification

When a new report is added to an account, subscribers receive a notification.

Report Detail page

Provides a read only detailed view of a report.

Reports page

Provides a list of available reports with a link to a page with details with a link to the target source of record for a more detailed view.

The official version of this content is in English. Some of the Citrix documentation content is machine translated for your convenience only. Citrix has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Citrix product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Citrix, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Citrix will not be held responsible for any damage or issues that may arise from using machine-translated content.

You agree to hold this documentation confidential pursuant to the
terms of your Citrix Beta/Tech Preview Agreement.

The development, release and timing of any features or functionality
described in the Preview documentation remains at our sole discretion and are subject to
change without notice or consultation.

The documentation is for informational purposes only and is not a
commitment, promise or legal obligation to deliver any material, code or functionality
and should not be relied upon in making Citrix product purchase decisions.