How to get live data from MS Project

%3CLINGO-SUB%20id%3D%22lingo-sub-1490211%22%20slang%3D%22en-US%22%3EHow%20to%20get%20live%20data%20from%20MS%20Project%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1490211%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20get%20live%20data%20from%20MS%20Project%20into%20Excel.%20Is%20there%20a%20way%20to%20set%20that%20up%20like%20a%20Query%20so%20you%20can%20hit%20a%20refresh%20button%20in%20Excel%20to%20update%20the%20information%20without%20ever%20going%20into%20MS%20Project.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20Power%20BI%20solve%20this%20problem%3F%20Do%20I%20need%20an%20ODBC%20driver%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20input%20would%20be%20greatly%20appreciated.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1490211%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I'm trying to get live data from MS Project into Excel. Is there a way to set that up like a Query so you can hit a refresh button in Excel to update the information without ever going into MS Project. 

 

Could Power BI solve this problem? Do I need an ODBC driver? 

 

Any input would be greatly appreciated. Thank you.

1 Reply