Skip to content

Latest commit

 

History

History
78 lines (47 loc) · 3.25 KB

publish-power-bi-desktop-to-power-bi.md

File metadata and controls

78 lines (47 loc) · 3.25 KB
Raw
title titleSuffix description ms.subservice ms.topic ms.assetid ms.author monikerRange author ms.date
Publish a Power BI Desktop file to Power BI
Azure DevOps
Learn how to publish and enable refresh of a Power BI Desktop file to Power BI that uses Analytics for Azure DevOps.
azure-devops-analytics
how-to
C03A04EC-F011-4043-A38E-5C5394F777CE
chcomley
>=azure-devops-2019
chcomley
10/05/2021

Publish a Power BI Desktop file to Power BI

[!INCLUDE version-gt-eq-2019]

Once you've created a Power BI Desktop file and the associated datasets, measures, and charts, you can share them with others by creating a dashboard on Power BI. This article shows you how.

Publish to Power BI

  1. If using an Analytics view, verify that the view is Shared and not Private.

  2. Open the Power BI Desktop file with your data.

  3. Select Publish on the Home tab.

    :::image type="content" source="media/publish-1.png" alt-text="Publish Power BI Desktop file":::

  4. Respond to the prompts to sign in. If you don't already have a Power BI account, you'll need to create one. Select Sign in.

    :::image type="content" source="media/publish-2.png" alt-text="Publishing successful":::

  5. Select the Open <file name> in Power BI link.

Configure refresh schedule

  1. Expand the navigation pane in Power BI and select the work space that you selected when you published the report.

  2. Select Datasets in the upper right corner.

  3. Select the ellipsis next to the dataset that represents the report you just loaded. It's typically the file name.

    :::image type="content" source="media/publish-3.png" alt-text="Select the dataset":::

  4. Select Schedule Refresh.

  5. Select the Edit credentials link next to ODATA under Data source credentials as shown here:

    :::image type="content" source="media/publish-4.png" alt-text="Update odata credentials":::

  6. Select the appropriate authentication option.

    • Use oAuth2 for Microsoft Entra ID or Windows credentials.

      Configure Areas dialog

    • Use Basic for PAT credentials.

      Configure Fabrikam Data dialog, Enter credentials

      [!IMPORTANT]
      If you are using a Personal Access Token, remember that the token expires on a set interval. When it expires you'll need to update the credentials. Otherwise the report, while still displaying data, won't update with the latest data.

  7. Select Sign in.

At this point, the data will update on your scheduled basis using the credentials entered.

Important

Any data included in the Analytics view and published Power BI will be accessible to all users with access to the report, regardless of the project permissions configured in Azure DevOps.

Related articles