Publish a Power BI Desktop file to PowerBI.com

Azure DevOps Services | Azure DevOps Server 2019

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

  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. Choose Publish on the Home tab.

    Publish Power BI Desktop file
  4. Respond to the prompts to sign in. If you don't already have a Power BI account you will need to create one. Choose Sign in.

    Publishing successful
  5. Choose the Open 'file name' in Power BI link.

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

  7. Choose Datasets in the upper right corner.

  8. Choose the ellipsis next to the dataset that represents the report you just loaded (this is typically the file name.

    Select the dataset
  9. Choose Schedule Refresh.

  10. Choose the Edit credentials link next to ODATA under Data source credentials as shown here:

    Update odata credentials
  11. Select the appropriate authentication option.

    • Use oAuth2 for Azure Active Directory (Azure AD) 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.

  12. Choose 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.com will be accessible to all users with access to the report, regardless of the project permissions configured in Azure DevOps.