I need to import data from MS-project (*.mpp file) to PowerBi.
I need free solution. So I cannot use MS Project Server
I try to do it with Python. But it has many problems and it is complicated to extend it.
There is code what I use in PowerBi:
import win32com.client
import pandas
doc = 'C:\file.mpp'
mpp = win32com.client.Dispatch("MSProject.Application")
mpp.Visible = 1
mpp.FileOpen(doc)
Project = mpp.ActiveProject
data = []
for i in range(1,Project.Tasks.Count+1):
if hasattr(Project.Tasks.Item(i), 'ResourceNames'):
for c in (Project.Tasks.Item(i).ResourceNames).split(";"):
alist= [c,Project.Tasks.Item(i).Text1,Project.Tasks.Item(i).Name]
data.append (alist)
df = pandas.DataFrame(data ,columns=['Resource','Customer','Task'])
Is there any better solution? Thanks.
