none
Using PowerBi for reports - anyone know a tutorial? RRS feed

  • Question

  • I'd like to use PowerBi to create a report from MS Project 2013; our company is already using PowerBi to extract data from our ERP system, which I'd like to combine with MS project data.

    It is my understanding that PowerBi will not import an MPP, so a conversion to XML is needed.

    Does anyone know of a good tutorial on this?

    Thanks!

    Andre

    Thursday, February 16, 2017 4:56 PM

Answers

  • Once you open a project schedule using Microsoft Project, you can then do a FILE/SAVE AS and select different file types such as XML, CSV or Excel.   If you save a Excel, then a Export Wizard will start and walk you thru several options on how you want to save the project schedule. 

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Marked as answer by Huismu5 Saturday, February 18, 2017 6:13 AM
    Friday, February 17, 2017 3:04 AM
    Moderator

All replies

  • Once you open a project schedule using Microsoft Project, you can then do a FILE/SAVE AS and select different file types such as XML, CSV or Excel.   If you save a Excel, then a Export Wizard will start and walk you thru several options on how you want to save the project schedule. 

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Marked as answer by Huismu5 Saturday, February 18, 2017 6:13 AM
    Friday, February 17, 2017 3:04 AM
    Moderator
  • Hi Huismu5,

    As Michael says you can export to another file type, but in the 1st instance you need to define what you are trying to report on.  You might the visual reports feature provides Excel data in a format you require and can read from PowerBI.


    Ben Howard [MVP] | web | blog | book

    Friday, February 17, 2017 7:31 AM
    Moderator
  • Thanks Ben and Michael,

    That'll work. I think I may use VBA to autosave a csv or xlsx version every time the MPP gets saved.

    Rg,

    Andre

    Saturday, February 18, 2017 6:15 AM