share ms project file with people that do not have ms project

However, when clicking ‘Preview’ or attempting to view the column list, Visual Studio locks up completely and you see the following message:įor me, the problem was very repeatable, and frustrating. The collection list is visible in the dropdown menu: Then create an OData Source within a data flow task using the same connection manager: For Project Online the service document location format is /sites/pwa/_api/ProjectData. Open up SQL Server Data Tools and create a new OData connection:Įnter in the credentials and service document location. However, this seemingly easy solution can have its share of problems, as experienced by colleagues and me while working on a project for one of our clients. On the surface, connecting to Project Online via SSIS is straightforward: Simply create an OData connection manager combined with an OData Source and then write to a database or flat file.

Connect to Project Online using OData Source Make sure that the user (login) that you will use to connect will need the appropriate permissions to access the OData feed as outlined in the service reference. In Project Online I’ve created a project, ‘testproject’, and made some tasks: So how can you bring data from Project Online into your existing reporting environment such as Qlik or Tableau? In this blog post I will show you a way to do that, along with a pesky bug that may accompany your implementation, and how to work through it.įor the setup we will use a fictional company, KTS LLC, with SharePoint and Project Online site collections located at. Additionally, you may not have the capacity, budget, or desire to introduce Power BI as a replacement for your existing solution. Your organization may already have a BI solution in place, so reverting back to decentralized Excel-based reporting is not ideal. Microsoft has tight integrations throughout their technology stack, so the easiest approach would be through Power BI or Excel. What if you want to get your data out of Project Online and into your existing BI environment for integrated reporting on things like costs, risks and issues, and completion status? There are several quality tools out there to assist with project management and workflow, but a lot of organizations use Microsoft Project due to its legacy and the depth of its features. Project management is important to any release. We'll also show you how to work through a pesky bug that may accompany your implementation. In this blog, we will show you how to bring data from Project Online into your existing reporting environment, such as Qlik or Tableau.

Share ms project file with people that do not have ms project