{"id":17566,"date":"2022-02-02T11:49:40","date_gmt":"2022-02-02T11:49:40","guid":{"rendered":"https:\/\/www.o365cloudexperts.com\/blog\/?p=17566"},"modified":"2022-02-02T13:56:26","modified_gmt":"2022-02-02T13:56:26","slug":"power-bi-with-microsoft-project","status":"publish","type":"post","link":"https:\/\/www.o365cloudexperts.com\/blog\/power-bi-with-microsoft-project\/","title":{"rendered":"How to Use Power BI with Microsoft Project?"},"content":{"rendered":"<p>Businesses and enterprises rely on project management tools to help their teams manage tasks and workflows effectively. Microsoft Project has been one of the most popular and widely used project management software for over 30 years. Developed with a focus on task prioritization and scheduling, Microsoft Project offers task lists, project roadmaps, Gantt charts, and Kanban boards, among other features. More importantly, Project is tightly integrated with other Microsoft applications such as Excel and <a href=\"https:\/\/www.o365cloudexperts.com\/microsoft-powerbi\/\">Power BI<\/a>. This helps managers keep close track of costs, risks and issues, and task completion status. In this article, we will focus on the integration of Power BI with Microsoft Project.<\/p>\n<h2 style=\"font-size: 23px;\">How to Connect Power BI with Project?<\/h2>\n<p>Integrating Power BI with Project involves the use of Power BI Desktop template, Dataverse, and Project Web App. Follow the steps below to connect Power BI with Project.<\/p>\n<ul style=\"text-align:justify\">\n<li style=\"margin-bottom: 10px;\">Set up Power BI on the desktop by following the instructions on the setup wizard.<\/li>\n<li style=\"margin-bottom: 10px;\">Install the Power BI template, which can be supported on at least Project Plan 3 and Power BI Desktop or Power BI Pro.<\/li>\n<li style=\"margin-bottom: 10px;\">Complete the installations of the Project for the web report pack, Project Online report, or consolidated reports, based on the requirements.<\/li>\n<li style=\"margin-bottom: 10px;\">Provide the Dynamics 365 Dataverse instance and Project Online Project Web App URL on the <strong>Enter Parameters<\/strong> screen.<\/li>\n<li style=\"margin-bottom: 10px;\">Authenticate with the Microsoft 365 account credentials.<\/li>\n<li style=\"margin-bottom: 10px;\">Project for the web data stores data in the Dynamics 365 Dataverse. Consequently, the environment name, and the region value for the Dataverse URL are required for transferring data to Power BI. To create a Dataverse URL, navigate to <strong>Apps &gt; All Apps<\/strong> in Office.com.<\/li>\n<li style=\"margin-bottom: 10px;\">Search for Business Apps and select the project application for which reports have to be generated for the organization. The Business Apps URL (Dataverse instance) that is created will include the environment and region value.<\/li>\n<li style=\"margin-bottom: 10px;\">Switch to the <strong>Project Online PWA<\/strong> site home page to find the Project Web App URL.<\/li>\n<li style=\"margin-bottom: 10px;\">Navigate to <strong>Go to Project Online<\/strong> from the Project Home page and copy the URL of the PWA Home page to be pasted in the PWA URL field in the Project template.<\/li>\n<li style=\"margin-bottom: 10px;\">Once the data from Project is shared with Power BI, publish reports to shared workspaces from Power BI Desktop, and configure the data refresh rates to ensure that the datasets are updated regularly.<\/li>\n<\/ul>\n<h2 style=\"font-size: 23px;\">Apps4Rent Can Help with Microsoft Project and Power BI Customization<\/h2>\n<p>While Microsoft provides native integration between Power BI and Project Web App, which is available as a part of <a href=\"https:\/\/www.o365cloudexperts.com\/project-plan-1-3-5-comparison\/\">Project Plan 3 and Project Plan 5<\/a>, Microsoft does not provide support for using Project Desktop and MPP (Microsoft Project files) as sources for Power BI Desktop. However, Project Server and Power BI can be integrated using Open Database Connectivity (ODBC) drivers and third-party tools for establishing a direct connection.<\/p>\n<p>As a Microsoft Power Platform Partner and a Gold Partner for competencies such as Cloud Platform and Application Integration, Apps4Rent can help businesses with licensing, hosting, and customizations of Microsoft cloud solutions such as Power BI and Microsoft Project. Call, chat or email our integration specialists available 24\/7 for assistance.<br \/>\n<a name=\"form\"><\/a><br \/>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f15786-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"15786\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/blog\/wp-json\/wp\/v2\/posts\/17566#wpcf7-f15786-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"15786\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.5\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f15786-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_group_fields\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_visible_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_repeaters\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_steps\" value=\"{}\" \/><input type=\"hidden\" name=\"_wpcf7cf_options\" value=\"{&quot;form_id&quot;:15786,&quot;conditions&quot;:[],&quot;settings&quot;:{&quot;animation&quot;:&quot;yes&quot;,&quot;animation_intime&quot;:200,&quot;animation_outtime&quot;:200,&quot;conditions_ui&quot;:&quot;normal&quot;,&quot;notice_dismissed&quot;:false}}\" \/><input type=\"hidden\" name=\"_wpcf7_recaptcha_response\" value=\"\" \/>\n<\/fieldset>\n<style>\ntextarea {\n font: 16px 'Roboto';\n font-weight: normal;\n font-style: normal;\n line-height: 25px;\n color: #2A363F;\n padding: 10px 20px !important;\n font-size: 18px;\n border: 1px solid #e0e0e0 !important;\n width: 99%;\n box-sizing: border-box;\n border-radius: 3px !important;\n}select{font: 16px 'Roboto';font-weight: normal;font-style: normal;line-height: 25px;color: #2A363F;font-size: 18px;border: 1px solid #e0e0e0 !important;width: 98.5% !important;box-sizing: border-box;border-radius: 3px !important;}.inputt{float: left;margin-bottom: 20px;margin-right:20px;padding: 10px; width:30.8% ;}.inputt1{float: left;margin-bottom: 20px;padding: 10px; width:33% ;}.post input[type=\"submit\"]{width: 90px !important;background: orange;border: #9d9fa0 1px solid !important;}.blogf{width:auto;margin-left: 10px;margin-right: 10px;margin-bottom:15px;}.blogf1{width: 31%;margin-left: 10px;margin-bottom:15px;}.blogaf{width: 28.6%;margin-bottom:15px;}.textarea{font-size:13px;}.mail{width:100%;}@media only screen and (min-width:99px) and (max-width:767px){.blogf1{width:100%;margin: 0px;}.inputt{width:100% ;}.inputt1{width:100% ;}.blogf{width:100%;margin: 0px;}.blogaf{width:100%;margin: 0px;}}\n<\/style>\n<div class=\"clearfix divider_line9 lessm artciles-between\">\n<\/div>\n<div style=\"padding: 3%;background-color: #f9f9f9;margin-bottom: 15px;\">\n\t<div>\n\t\t<p style=\"text-align:center;color: #3183d7;font-size: 27px;font-weight: 500;margin-bottom: 40px;\">Submit Your Requirement\n\t\t<\/p>\n\t<\/div>\n\t<p><a name=\"mobform\" class=\"mobform\"><\/a>\n\t<\/p>\n\t<div >\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"Name\"><input size=\"39\" maxlength=\"60\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required inputt\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Name\" value=\"\" type=\"text\" name=\"Name\" \/><\/span><span class=\"wpcf7-form-control-wrap\" data-name=\"Email\"><input size=\"39\" maxlength=\"60\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email inputt\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Email ID\" value=\"\" type=\"email\" name=\"Email\" \/><\/span><span class=\"wpcf7-form-control-wrap\" data-name=\"ContactNumber\"><input size=\"39\" maxlength=\"60\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required inputt1\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Contact Number\" value=\"\" type=\"text\" name=\"ContactNumber\" \/><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"mailbox\"><input size=\"35\" maxlength=\"60\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required mail\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Number of Mailboxes*\" value=\"\" type=\"text\" name=\"mailbox\" \/><\/span>\n\t\t<\/p>\n\t\t<div style=\"margin-bottom:15px;\">\n\t\t\t<p><span class=\"wpcf7-form-control-wrap office365\"><select name=\"office365\" class=\"wpcf7-form-control wpcf7-select\" aria-invalid=\"false\" style=\"width: 100% !important;padding: 3px;width: 81.5%; padding: 10px 5px !important;border: solid 1px #e0e0e0;border-radius: 3px;;font-size: 13px;color: #656565;\"><option value=\"Select\">Migrating From?*<\/option><option value=\"Exchange\">Exchange<\/option><option value=\"POP3\/IMAP\">POP3\/IMAP<\/option><option value=\"G Suite\">G Suite<\/option><option value=\"Rackspace\">Rackspace<\/option><option value=\"Office 365\">Office 365<\/option><option value=\"Mozilla Thunderbird\">Mozilla Thunderbird<\/option><option value=\"Lotus Notes\">Lotus Notes<\/option><option value=\"Outlook.com\">Outlook.com<\/option><option value=\"Kerio\">Kerio<\/option><option value=\"GroupWise\">GroupWise<\/option><option value=\"SharePoint\">SharePoint<\/option><option value=\"Others\">Others<\/option><\/select><\/span>\n\t\t\t<\/p>\n\t\t<\/div>\n\t\t<p><span class=\"wpcf7-form-control-wrap your-message\"><textarea name=\"your-message\" cols=\"117\" rows=\"6\" class=\"wpcf7-form-control wpcf7-textarea\" maxlength = \"400\" aria-invalid=\"false\" placeholder=\"Your Message*\" style=\"\nwidth: 100%;font-size:13px;\"><\/textarea><\/span>\n\t\t<\/p>\n\t<span class=\"wpcf7-form-control-wrap recaptcha\" data-name=\"recaptcha\"><span data-sitekey=\"6Lc6Z9IUAAAAAGTl0gnruY5FQ7_3OHWPvUwul-Zo\" class=\"wpcf7-form-control wpcf7-recaptcha g-recaptcha\"><\/span>\r\n<noscript>\r\n\t<div class=\"grecaptcha-noscript\">\r\n\t\t<iframe loading=\"lazy\" src=\"https:\/\/www.google.com\/recaptcha\/api\/fallback?k=6Lc6Z9IUAAAAAGTl0gnruY5FQ7_3OHWPvUwul-Zo\" frameborder=\"0\" scrolling=\"no\" width=\"310\" height=\"430\">\r\n\t\t<\/iframe>\r\n\t\t<textarea name=\"g-recaptcha-response\" rows=\"3\" cols=\"40\" placeholder=\"reCaptcha Response Here\">\r\n\t\t<\/textarea>\r\n\t<\/div>\r\n<\/noscript>\r\n<\/span>\n\t\t<p>&nbsp;<br \/>\n<input class=\"wpcf7-form-control wpcf7-submit has-spinner button-co\" type=\"submit\" value=\"Send\" \/>\n\t\t<\/p>\n\t<\/div>\n<\/div><p style=\"display: none !important;\" class=\"akismet-fields-container\" data-prefix=\"_wpcf7_ak_\"><label>&#916;<textarea name=\"_wpcf7_ak_hp_textarea\" cols=\"45\" rows=\"8\" maxlength=\"100\"><\/textarea><\/label><input type=\"hidden\" id=\"ak_js_1\" name=\"_wpcf7_ak_js\" value=\"211\"\/><script>\ndocument.getElementById( \"ak_js_1\" ).setAttribute( \"value\", ( new Date() ).getTime() );\n<\/script>\n<\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Businesses and enterprises rely on project management tools to help their teams manage tasks and workflows effectively. Microsoft Project has been one of the most popular and widely used project management software for over 30 years. Developed with a focus on task prioritization and scheduling, Microsoft Project offers task lists, project roadmaps, Gantt charts, and [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1177,1167],"tags":[],"class_list":["post-17566","post","type-post","status-publish","format-standard","hentry","category-microsoft-project","category-power-bi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/posts\/17566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/comments?post=17566"}],"version-history":[{"count":1,"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/posts\/17566\/revisions"}],"predecessor-version":[{"id":17567,"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/posts\/17566\/revisions\/17567"}],"wp:attachment":[{"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/media?parent=17566"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/categories?post=17566"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/tags?post=17566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}