This guide will walk you through how to set up PowerBI Connector in Datalogz via service principal. This method allows read-only access to PowerBI's administrative APIs for a single PowerBI tenant.

Time estimated: 6 mins

To start, we need the following:

1. Azure App registration → https://portal.azure.com/#view/Microsoft_AAD_RegisteredApps/ApplicationsListBlade

2. Azure Group creation → https://portal.azure.com/#view/Microsoft_AAD_IAM/GroupsManagementMenuBlade/~/Overview

3. PowerBI configuration → https://app.powerbi.com/admin-portal/tenantSettings

4. Datalogz account & license activation -> contact customers@datalogz.io

5. Log in to your Datalogz account → https://app.datalogz.io/#/organization/connectors

Step 1: Create a new App Registration

1. Open App registrations link -> https://portal.azure.com/#view/Microsoft_AAD_RegisteredApps/ApplicationsListBlade

2. Create New Registration
3. Create a name for your app, select single tenant (first option) as a supported account type, ignore the optional field as needed, and click Register at the bottom.

In this new app, we will need three pieces of information

1. Application (client) ID & Directory (tenant) ID

1. Client Secret Value

   1. Under Manage in the side nav

   2. Click Certificates & secrets & create new

   3. Find the Client Secret Value

Grant Permissions for the new App Registration Here add permissions specifically for the Power

• Tenant.ReadWrite.All

• Dataset.ReadWrite.All

Step 2: Create a new Group in Azure

1. Click and open Azure Group link https://portal.azure.com/#view/Microsoft_AAD_IAM/GroupsManagementMenuBlade/~/Overview

2. Create a new group
3. Add members by adding the new app to the Enterprise applications
4. Create new group

Step 3: Configure PowerBI with the Group

1. Open PowerBI Tenant Settings: https://app.powerbi.com/admin-portal/tenantSettings

2. In the Admin Portal's keyword search box type "XMLA", and in the Integration settings section enable "Allow XMLA endpoints and Analyze in Excel with on-premises semantic models"
3. In the Admin Portal's keyword search box type "fabric api" and enable "Service Princepals can use Fabric APIs"
4. In the Admin Portal's keyword search box type "admin api".
5. Enable all three Admin API settings and apply all newly created Groups.
6. Note: This configuration can take 15-25 mins for changes to work its way through PowerBI.

Step 4: Create a New Connector in Datalogz

1. Log in to your Datalogz account

2. Navigate to Connector in the sidebar, and click New Connector
3. Choose PowerBI, and select Connect using a Service Principal (SP)
4. Copy-paste the new application information.

   1. Directory (tenant) ID

   2. Application (client) ID

   3. Client Secret Value

Step 5: Reload the connection in Datalogz

1. Select a PowerBI workspace

2. Reload Workspace and select all, option to expand and choose personal workspace

3. Rename Connection and Continue to Next Step.

4. Schedule the Connector Refresh rate.

5. Refresh and click to view the new connector.

For more questions, please contact Datalogz support support@datalogz.io

Capacity Monitoring (Additional Setup)

1. Navigate to the Admin Portal and enable the Integration Setting for Semantic Model Execute Queries REST API. When enabled, users in the organization can query semantic models by using Data Analysis Expressions (DAX) through Power BI REST APIs.
2. The full documentation for the "Microsoft Fabric Capacity App" can be found in Microsoft's Doc pages. While you can use an existing Fabric Capacity Metrics app setup in PowerBI it's suggested to get the app again and setup a workspace specifically for use with Datalogz.

   1. Install the Microsoft Fabric Capacity App in your Power BI environment. Navigate to the "Apps" section on the side bar of Power BI. There you can search for the "Microsoft Fabric Capacity App" and add it.

   2. Navigate to the "Microsoft Fabric Capacity Metrics" Workspace that is created with the app. Go to Manage Access and grant "Admin" permissions to the Datalogz service principal Groups.

   3. Run the app for the first time to start data flowing into the semantic model.

3. Provide the Dataset ID for the "Fabric Capacity Metrics" to Datalogz. This can be found in the URL when viewing the semantic model in your web browser.

   1. Sample :

This guide will walk you through how to set up a Tableau connector in Datalogz via Tableau Cloud.

Time estimated: 4 mins.

To start, log in to the following:

1. Log in to your Datalogz account →

2. Sign in to Tableau Cloud

Step 1: Create a new connector in Datalogz

1. Navigate to Connector in the sidebar, and click New Connector
2. Choose Tableau

Step 2: Fill in the Connector details

1. Copy-paste Host and Site Name in the URL
2. Find the latest Rest API Version

Create Access Token Name

1. In the Tableau home screen, click on the user profile icon. Under account settings, find personal access tokens.
2. Name & create a new token
3. Copy-paste Token details, and connect the connector

   1. Secret to Access Token Secret < Warning: this Secret will disappear after closing this dialog box>

   2. Token Name to Access Token Name

4. Name the connector select projects, and continue.

5. Set refresh schedule and finish the connector set up.

This guide will walk you through how to set up Qlik Connector in Datalogz using the Virtual Proxy Authentication Method.

Time estimated: 6 mins.

To start, We need:

1. Hostname, the address at which we access Click.

2. Virtual Proxy details

3. (Optional) N-Printing details

Create a New Connector in Datalogz

1. Log in to your Datalogz account

2. Navigate to Connector in the sidebar, and click New Connector
3. Choose Qlik

1. Copy-paste

   1. Hostname, the address at which we access Click.

   2. Virtual Proxy details

   3. (Optional) N-Printing details

1. Select Streams to extract.

For more questions, please contact Datalogz support support@datalogz.io