17966
Skip to product information
1 of 2

Digital Factory

T12/ MS Project - Tutorial: Connecting the MS project with Power BI

T12/ MS Project - Tutorial: Connecting the MS project with Power BI

Regular price €19,00
Regular price Sale price €19,00
Sale Sold out

Paid Tutorial: An access link will be sent to you after purchase.

In this MS Project tutorial, you will learn how to connect your project planning with 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 that are not necessary for the 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 table. Next, go to the File tab , click Export , and then choose Save As . Save the file as Excel, give it a suitable name and click Save .

A window will open to map the fields to export. Select "Selected Data" , create a new mapping, and then click Next . Choose “Tasks,” then click Next again . Next, choose “Based on tables” and select the Power BI display board. 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 Upload . 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 let's say 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 Table , then click Enter . We will now re-export this table. Follow all the export steps again, making sure to select the updated table and verifying that the Resources column is present.

Once the export is complete, return to Power BI and refresh.

Your report is up to date now. Thanks for following this tutorial!

  • Access your product in 30 seconds: steps 👇
View full details
1 of 5

FAQs

How will I receive links to the videos?

Links to the videos will be sent to the email address you used to place your order. Be sure to check your inbox and spam folder.

Will I have unlimited access to videos?

Yes, you will have unlimited access to videos for life. You can watch them as many times as necessary to fully assimilate the content.

Are the videos downloadable?

No, the videos are not downloadable. They are only accessible online via the links provided after ordering.

Can I share video links with others?

No, video links are strictly personal and should not be shared. They are intended solely for the use of the buyer.

Is there support available if I have questions about the content of the videos?

Yes, if you have any questions about the content of the videos, you can contact us at [hello@digitalfactory.store]. We would be delighted to help you.

Customer Reviews

Be the first to write a review
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)

Subscription offers

Subscription - Access to Excel, Power BI and Ms project tutorials and models

Monthly Subscription

€39.90 /month
  • Full access to all tutorials:
  • MS Project: Planning, Resources
  • Power BI: Data Preparation, Dashboards
  • Power Automate: Workflow Automation
  • Full access to all models:
  • Project management, Operational efficiency, Lean,...
  • Premium Dashboards Included
  • Unlimited downloads
  • Personal space included
  • 30 minute support included
Subscribe

Annual Subscription

€299.00 /year
  • All the advantages of the monthly
  • Save 36% compared to monthly
  • Priority consultation with an expert
  • Updates and new models every week
Subscribe

Free

0 €
  •  Access to free models
  • Access to free tutorials
  • News and Updates
Subscribe

Any questions?

Make an appointment with an expert via Google Calendar Appointment
Or
Write to Us

Contact form

  • Opérateur utilisant des jumeaux numériques pour monter des composants sur un moteur - l'industrie 4.0

    Digital twins in industry 4.0

    Digital twins represent a major innovation in the Industry 4.0 landscape, offering new ways to optimize industrial processes and boost operational efficiency. These virtual models, which are digital replicas of...

    1 comment

    Digital twins in industry 4.0

    Digital twins represent a major innovation in the Industry 4.0 landscape, offering new ways to optimize industrial processes and boost operational efficiency. These virtual models, which are digital replicas of...

    1 comment
  • Image d'une équipe réunie pour clôturer un projet de conduite de changement réalisé avec succés, l'équipe projet est satisfaite des résultats

    Change Management: The Complete Guide to Change...

    Introduction With the emergence of Industry 4.0 , characterized by the integration of digital technologies such as the Internet of Things (IoT) , artificial intelligence (AI) , and advanced robotics...

    Change Management: The Complete Guide to Change...

    Introduction With the emergence of Industry 4.0 , characterized by the integration of digital technologies such as the Internet of Things (IoT) , artificial intelligence (AI) , and advanced robotics...

  • Ville entière connectée à l'aide des capteurs intelligents et une plateforme IoT - Digital factory

    All about IoT platforms

    In today's industrial sector, digitalization is key to advancing production and activity management. This article explores IoT platforms, central systems that control networks of connected objects, providing a centralized interface...

    All about IoT platforms

    In today's industrial sector, digitalization is key to advancing production and activity management. This article explores IoT platforms, central systems that control networks of connected objects, providing a centralized interface...

1 of 3