Feb 26th vPlanner and PowerBI

Feb 26th vPlanner and PowerBI

Agenda
  1. Integrating vPlanner data into a PowerBI Dashboard via the API
  2. Example Dashboard Setup
  3. QA
Link to the Recording: 
​

vPlanner & Power BI

Admin level users can get an API key that will allow access to vPlanner metrics directly from Power BI.  For this to work, a user can obtain an API key using the vPlanner client.  The key will enable read-only access to vPlanner PPC metrics data so that they can be placed in Power BI dashboards.  You should treat the API key like a password and do not share it with anyone.  The key will be valid for 30 days and needs to be renewed regularly during the early phases of V5.  It will expire if the Admin user's account is disabled.  

Go to Ribbon/Setup and Click on Generate API Key
You will see a message box to confirm as once the new key is issued, any previous keys will become invalid.  When the Api Key window appears, copy the key to the clipboard.

Valid vPlanner URI paths include the followings that you can use depending on the type of report you would like to produce:
    1. PPC - All Active Projects: https://client.vplannerapp.com/api/workplanmetrics/allprojects
    2. PPC - Single Project: https://client.vplannerapp.com/api/workplanmetrics
    3. Variances - All Active Projects: https://client.vplannerapp.com/api/workplanmetrics/variances/allprojects
    4. Variances - Single Project: https://client.vplannerapp.com/api/workplanmetrics/variances
Under HTTP request Header Enter: Authorization in the first box.
Enter Bearer [APIKEYVALUE] in the second box without the brackets. You should be able to connect and get data from the vPlanner server.


   


    • Related Articles

    • Feb 24th Overview of how vPlanner Calculates a Plan

      Agenda Overview of how vPlanner calculations work QA Link to the Recording: Webinar Recording

    • Feb 27th vPlanner Basics for Non-Admin Users

      Agenda Basics of using vPlanner including task creation, finding your tasks, working with various views, making and updating commitment status. QA Link to the Recording: Webinar Recording

    • vPlanner Help Center

      Welcome to the vPlanner help center where you can create support tickets and check on the status of your requests.

    • vPlanner Overview Webinars

      Overview of vPlanner V5 vPlanner V5 features a newly designed user interface that is organized into various working views each with its own set of tools in ribbons. Common themes across the various ribbon tools will make it easer to find the relevant ...

    • vPlanner-V5 Release Candidate Download

      The vPlanner V5 Release Candidate Version is available to all users and can be used in production. Using vPlanner V5 with vPlanner V4 You can use V4 and V5 on the same project at the same time. For V4 users working along side V5 users, there is no ...