Publish PowerBI files with Visual Studio Team Services

Today I published an extension for Visual Studio Team Services (VSTS) that gives you the ability to deploy PowerBI files (pbix) to PowerBI.com. It uses the PowerBI API that has the following operations (at the time of writing this article):

All other information about the API can found on MSDN: https://msdn.microsoft.com/en-us/library/mt147898.aspx

VSTS PowerBI Extension

Start using the extension in VSTS

To start with the extension you will need to meet the prerequisites:

  • Account with access to PowerBI
  • Azure Active Directory application with access to the PowerBI API

This means you will have to register an application within Azure Active Directory to be able to use the PowerBI API. The user that publishes the dashboards from VSTS should have access to the application created in Azure Active Directory.

The below figure gives an example for an Azure Active Directory application.

Azure Active Directory Application

 

The application itself needs to be configured with the following permissions.

Application Permissions

Future Releases

This is the first release, if you have any suggestions or remarks please let me know. I will try to add those within a new release.

Other information about the extension:

Related Posts

Updates to my VSTS extensions Since a couple of months I have been developing extensions for Visual Studio Team Service (VSTS). I created extensions for task I had to do manual a c...
Invoke Azure Function in your Visual Studio Team Services CI/CD pipeline A utility task is available for Visual Studio Team Services (VSTS) to invoke an http triggered Azure function. The ability to invoke a Function from y...
VSTS Extension for Azure Role Based Access Control Today I published an extension for Visual Studio Team Services (VSTS) that gives you the ability to add and remove role based access assignments in Az...
VSTS build or release agent on a self hosted machine in Azure or on premise You can think of many situations where you would like to create a self hosted machine for Visual Studio team services (VSTS). Installing and configuri...
My first public VSTS Extension A couple of days ago I started developing extensions for Build and Release pipelines of Visual Studio Team Services (VSTS). One of these extensions is...
Protect your master Branch in VSTS You can set up permissions and policies to control who can read and update code in a branch on your Git repo within VSTS. You can set permissions for ...

3 comments

  • Hi Maik, this looks really great! Will try this out as soon as my time allows. We are currently working in a project where we want to “repoint” the datasource / connection of a dataset in order to show to an UAT data source first, and once testing is finished, we want to switch it to the production data source. So far we tested the newly available API to update datasource settings (https://msdn.microsoft.com/en-us/library/mt771178.aspx) using Microsoft Flow and PowerShell. Of course it would be much easier and straight forward if we could use your extension out of Visual Studio as we already do the version control using Visual Studio and VSTS.

    Cheers
    Raphael

    • Hi Raphael,
      The extension it self only supports publishing pbix files at the moment. Can look at a possibility “repoint” the datasource to another connection.
      I’m also willing to add that to the extension as well. Do you have scripts available that I could in corporate in the solution or maybe work together.
      Cheers,
      Maik

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.