T12/ MS Project - Tutorial: Connecting the MS project with Power BI
In this MS Project tutorial, you will learn how to connect your project schedule with a Power BI using an export of an excel file as a connection gateway.
To get started, go to the View tab, then click Table and choose More Tables . Select the 'Export' table from the drop-down menu, then click Edit . A new window will open, allowing you to choose the columns you want to export. Remove columns not needed for analysis and add those that are essential . Name your table and click OK , then click Apply to verify your export table.
To return to the old table, click Table and select the old one. Next, go to the File tab , click Export , then choose Save As . Save the file as Excel, give it an appropriate name and click Save .
A window will open to map the fields to export. Select "Selected data" , create a new mapping, then click Next . Choose "Tasks", then click Next again . Next, choose "Based on tables" and select the Power BI pinboard. Make sure all columns are mapped correctly. Click Next , save your mapping, and click Finish . Your export file is now created.
Now open Power BI, click Connect , choose Excel Files , select your exported Excel file, check the fields and click Load . Your exported data is now connected to Power BI.
When you update your project, remember to re-export the file overwriting the old file, so that the data is refreshed using the mapping we created.
Now suppose we want to add the Resource column to our export for analysis in Power BI. To do this, go back to Microsoft Project, click View , click Table , click More Tables , and then edit the Export table we created. Add the Resources column . Click OK , then click Apply to verify.
To return to the old table, click on Table , then on Enter . We are now going to re-export this array. Go through all the export steps again, making sure to select the updated table and checking that the Resources column is present.
When the export is complete, return to Power BI and refresh.
Your report is up to date now. Thanks for following this tutorial!
.🌟 Exclusive Sponsorship Offer! 🌟
We invite you to participate in our exceptional sponsorship program and win a €50 voucher!
🚀 How to participate?
- Follow us on YouTube /LinkedIn.
- Share our page/this post with your friends and network.
- Send us an email to email@example.com confirming that you followed and shared, and we'll send you your voucher!
🎁 Benefits for you:
- Receive a €50 voucher to use on our site!
- Discover a preview of our new products, exclusive offers and exciting content!
📜 Terms & Conditions:
- Only one voucher per person.
- The voucher is valid for any purchase on our site.
- Offer valid while vouchers are available.
👥 Join us and let’s grow the Digital Factory Store community together!