--- title: "Power BI" slug: "power-bi" updated: 2026-07-28T15:07:13Z published: 2026-07-28T15:07:13Z canonical: "learn.workforceexperience.hp.com/power-bi" --- > ## Documentation Index > Fetch the complete documentation index at: https://learn.workforceexperience.hp.com/llms.txt > Use this file to discover all available pages before exploring further. # Power BI > [!CAUTION] > **Important:** Before proceeding, please ensure you have followed **One User One Account** instructions [**HERE**](/wxp/docs/overview-of-connectors). This ensures you do not experience any authentication conflicts. Power BI is a business intelligence and analytics platform that enables users to connect to data sources, transform raw data into actionable insights, and create interactive reports and dashboards. ### Key features of Power BI 1. **Data Connectivity**: Power BI supports databases (like SQL Server and Oracle), cloud services (including Azure and Salesforce), and files (such as Excel) to merge and analyze data from different sources. 2. **Data Preparation**: Power BI provides data preparation tools to clean, transform, and model data, including data shaping, profiling, and cleansing features. 3. **Data Visualization**: Power BI's core feature is its robust data visualization capabilities. It lets you create interactive reports and dashboards with bar charts, line charts, maps, and other visualizations. 4. **Advanced Analytics**: Power BI has built-in advanced analytics, including forecasting, clustering, and regression analysis, to uncover deeper insights from your data. 5. **Natural Language Querying**: Power BI's Q&A uses AI to let you query data using natural language instead of complex formulas. ## Power BI Connector The Power BI Connector extracts, transforms, and visualizes data in real-time. It creates dynamic reports and dashboards that deliver actionable insights. ## Supported Operations The Power BI Connector supports a range of operations for data extraction and visualization: 1. **Data Visualization**: Enables data streams into Power BI for interactive reports. 2. **Reporting**: Refresh data for up-to-date decision-making. 3. **Data Transformation**: Cleanse, structure, and prepare data for analysis in Power BI. 4. **Data Sharing**: Share insights with stakeholders via Power BI’s collaboration tools. ## Key Functionalities The Power BI Desktop Connector extracts, cleanses, and prepares data from the HP Workforce Experience (WXP) platform for local analysis in Power BI Desktop. It enables users to work with and visualize data offline before publishing it to the Power BI Service. ## Integration Workflow 1. **Data Extraction**: The Power BI Connector extracts data from WXP using the designated APIs. 2. **Data Cleansing and Preparation**: The extracted data is cleansed and prepared to ensure accuracy and consistency. 3. **Data Import**: Power BI imports cleaned data for analysis and reporting. 4. **Visualization and Analysis**: Create interactive reports and dashboards with Power BI visualization tools. > [!NOTE] > **Note:** A Platform Account (HPID) with Report Admin or IT Admin rights is required. Creating a service account is the recommended approach. ## **Prerequisites** 1. A Microsoft Power BI Pro or higher license. 2. IT Administrator permissions. 3. Ensure you have followed **One User One Account** instructions [here](/wxp/docs/overview-of-connectors#wxp-user-creation). 3.1. Login to [https://app.powerbi.com](https://app.powerbi.com). In the top menu, **click** the gear icon ![](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/image(36).png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D). 3.2 Under **Governance and insights**, click **Admin Portal**. 3.3 In the **Admin portal** page, go to **Tenant** **Settings**. ![](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-jaswqt2p.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D)3.4 Search for **Create Workspaces** on the right side. 3.5 Under **Workspace Settings**, click **Create Workspaces**. ![createworkspace](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-y2rvgmci.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D)3.6 Expand the **Create Workspaces** arrow to view two **Apply to** options. ![a15](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-mdjyw9vh.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 3.7 Select **Specific security groups** (Recommended as it is less intrusive). 4. Access to Microsoft Power BI. 5. The WXP user must have the Connector Admin role assigned to access and use integrations and connectors within the WXP platform. 6. For information related to Role-Based Access Control (RBAC), refer to the [Authentication section](/wxp/docs/overview-of-connectors#authentication). 7. Ensure **WorkspaceV2** is enabled in **Power BI** (administrator privileges required). > [!NOTE] > **Note:** Selecting “The entire organization” is not recommended. 4. Log in to [https://portal.azure.com](https://portal.azure.com) 5. Under **Manage Microsoft Entra ID**, click **View**. ![a16](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-reqyl7v9.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 5.1 In the **Overview** page, click **Groups**. 5.2 On the right side, click **Add > Group**. ![a17](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-wue10n02.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 6. In the **New Group** page, under **Group type,** add a group. (For example, you can add a **Group name** PowerBIWorkspaceAccessGroup). 6.1 On the right side, under the **Add members,** select the checkbox to add a designated connection user as a member. ![a18](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-ndba1p7c.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 7. In **Power BI**, go to **Tenant settings**. 7.1 Under **Workspace settings**, select the radio button **Specific security groups.** 7.2 In the **Search** field, type the group name (e.g., PowerBIWorkspaceAccessGroup) and select it. ![a19](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-qwxvsxtg.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 7.3 Click **Apply.** ### How to Activate 1. In the WXP, go to **Integrations** **> Power BI** card**.** 2. Click **Configure.** 3. In the pop-up, select the reports to import into **Power BI.** > [!NOTE] > **Note:** Ensure you select all necessary reports. Changing the report selection after the connection is established will result in a new Power BI workspace. ![configure](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-sqf21vst.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 4. Click **Save.** ![a3](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-mnfxfsfw.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 1. In the **Power BI** card, click **Connect.** ![a4](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-5n61pr4x.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 2. Read the pop-up details. Click **Connect.** ![a6](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-d8yl3x1l.jpg?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 1. Sign in to **Power BI**. 7.1 Sign in with a Microsoft account and credentials. 7.2 Authorized users will see the **Permissions requested** page. Leave the checkbox **‘Consent on behalf of your organization’** unselected. Click **Accept**. ![](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/image-L1CE9L2B.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) The Power BI integration card displays **Connected**. The **Connect** button changes to a **Disconnect** option. ![a9](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-jvavdhb4.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) > [!NOTE] > **Note:** Allow a few minutes for the reports to appear in Power BI (Note that larger datasets might take longer to process). 1. In the **Power BI** card, click **Configure** to change the report selection. The system will create a new workspace with your updated selections during the next 24-hour scheduled run. 2. Check the following section after a successful Power BI connection. ### After Connect 1. Login to [https://app.powerbi.com.](https://app.powerbi.com.) In the left menu, click **Workspaces**. Successful integration results in a workspace (For example, **HPAnalytics** with a date and time suffix). ![a10](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-5cst9gwp.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 2. Click the newly created workspace name, followed by the data set (For example, the name starts with **HP Analytics**). ![a11](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-g2ce2ov2.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 3. On the right side, under **Tables,** the selected reports are visible. ![a12](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-pa4zk9n6.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 4. In the **Discover business insights** card, click **Explore this data**. ![a13](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-8198aud2.jpg?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 1. On the right, under **Data**, select columns from the tables to generate the reports. ![a13](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-9rewzhjq.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) ### Power BI Data Connection and Refresh Schedule - **Estimated time for initial data pull**: Maximum 10 minutes. - **Data refresh frequency**: Every 24 hours from connection time. - Note: The ‘**Refreshed**’ time listed for a semantic model does not currently update alongside each refresh. It retains the time at initial creation. ### **Troubleshooting Tips** 1. **Error: "Connection Failed"** ![a14](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/power-bi_v1a-image-ezg86gjz.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) **Cause:** A "**Connection failed**" error occurs when **WorkspaceV2** creation is not enabled on the tenant. (Administrator privileges are required to enable this setting.) **Solution**: Please check step 2 in the [Prerequisites](/wxp/docs/power-bi#prerequisites) section above. 2. **No Data Visible in Power BI** **Cause**: Data may not be visible because a user may have access to multiple accounts, which results in a tenant ID mismatch. **Solution**: Follow the following steps: 1. **Verify WXP Portal Account Access** Check in the WXP portal if your email is associated with more than one account or tenant. If so, there is a possibility of an authentication conflict, as the system may have authorized against an unintended account. ![](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/image (5).png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) ![](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/image (3).png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) ![](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/A screenshot of a computer AI-generated content may be incorrect_.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 2. **Reauthorize the Connector with a Single-Account Email (IT Admin role)** - Navigate to the Connector in WXP portal - Note: If the connector is already connected, the Authorize step may not be visible In this case, disconnect the connector first to make the Authorize option visible again. - Click the link next to Authorize step and reauthorize using an email that has access to only one WXP account/tenant to avoid cross-tenant conflicts. ![](https://cdn.us.document360.io/c9ecd56a-08d4-4e2f-ab71-60540f7ba8f3/Images/Documentation/A screenshot of a screenshot of a computer AI-generated content may be incorrect_.png?sv=2026-02-06&spr=https&st=2026-10-31T08%3A20%3A14Z&se=2026-10-31T09%3A20%3A14Z&sr=c&sp=r&sig=29bX6OOuiZW8Ed0GfyDwhmawZoww1khd8R5DBclalkE%3D) 3. **Reconnect the Connector** After successful reauthorization, reconnect the connector with Connector Admin role to re-establish proper access. 4. **Verify Data Visibility** Once the connector is properly connected, the user should be able to view the data as expected. ## Contact Us For any assistance, create a [support case](/wxp/docs/creating-a-support-case) or email [support@wxp.hp.com.](mailto: support@wxp.hp.com)