Microsoft Power BI Integration | Online Help | Zoho Projects

Microsoft Power BI Integration

Microsoft Power BI is an advanced analytical tool that helps analyze trends, stats, and create detailed reports. Integrate Power BI with Zoho Projects to sync your project data, visualize it, create dashboards and reports, and share them with your project stakeholders. Once integrated, Zoho Projects data set will be accessible directly from your Power BI Workspace.

Info
Feature Availability : Latest user-based Enterprise Plan (including bundles)
Alert
Requirement: Microsoft Fabric License is required

Install Microsoft Power BI

To install,
  1. Click the  icon in the top navigation bar.
  2. Navigate to Marketplace > All Apps.
  3. Click Microsoft Power BI for Zoho Projects > Install.

Authenticate Microsoft Power BI

You must be an admin in your Power BI Workspace to authenticate.
  1. Click the  icon in the top navigation bar.
  2. Navigate to Marketplace > Installed Apps.
  3. Click Microsoft Power BI for Zoho Projects.
  4. Click Authenticate.
  5. Enter your account details and click Proceed.
  6. Once authenticated, you will land on the configuration page in Zoho Projects.

Configure Microsoft Power BI

To configure,
  1. In the Configuration page, select your Power BI Workspace from the Workspace field.
  2. Click Next.
  3. Set the Auto-Sync Frequency to sync data at regular intervals (once every 24 hours).
  4. Select the module and the corresponding fields to sync the data.
  5. Click Save.

Edit Configuration

To edit the configuration,
  1. Click the  icon in the top navigation bar.
  2. Navigate to Marketplace > Installed Apps.
  3. Click Microsoft Power BI for Zoho Projects.
  4. In the Configuration page, hover over the module name and click the edit icon () in the Selected Fields Count column.

Sync Project Data

Even with Auto-Sync enabled, you can manually sync project data with Power BI:
  1. Click the  icon in the top navigation bar.
  2. Navigate to Marketplace > Installed Apps.
  3. Click Microsoft Power BI for Zoho Projects.
  4. On the Configuration page, click Sync Now.
You can manually sync data once until the next auto sync.

Manage Project Data in Power BI

Access synced data from Zoho Projects in your Microsoft Power BI Workspace:
  1. Open your Power BI Workspace.
  2. Click the latest synced Zoho Projects dataset.

  3. Select the data file to use to create a report.

  4. Select the modules and fields to visualize in your reports.

Manage Project Data in Power BI Desktop

  1. Open your Power BI Desktop.
  2. Click Get Data from the top band.
  3. Select Power BI semantic models.
  4. Use the latest synced Zoho Projects dataset to create reports.

Delete Power BI Integration

  1. Click the  icon in the top navigation bar.
  2. Navigate to Marketplace > Installed Apps.
  3. Click Microsoft Power BI for Zoho Projects.
  4. Click Delete Integration.
Deleting the integration will not remove any synced data in Power BI. Only the configuration will be deleted.
More Reads
Back to Help
Microsoft Integrations