https://community.fabric.microsoft.com/t5/Power-Query/Project-Online-task-constraint-information/m-p/3761825#M123797 <P>Hi,</P><P>I am reporting on project schedules from&nbsp;Project Online. There is a lot of task information that isn't available in the standard ODATA connection. I have managed to discover where task predecessor and successor information is stored and imported that. This gives me task lead and lag informatin as well as dependencies.</P><P>&nbsp;</P><P>I also need task constraint information - that is, whether tasks have Start No Earlier than, Finisish No Ealier than (etc) constraints, and if so, what the associated dates are.</P><P>&nbsp;</P><P>I have found nothing myself, and no search results match what I'm looking for. Has anyone managed to import this information into Power BI?</P> Wed, 13 Mar 2024 23:05:52 GMT Wellingtoon 2024-03-13T23:05:52Z https://community.fabric.microsoft.com/t5/Power-Query/Project-Online-task-constraint-information/m-p/3761825#M123797 <P>Hi,</P><P>I am reporting on project schedules from&nbsp;Project Online. There is a lot of task information that isn't available in the standard ODATA connection. I have managed to discover where task predecessor and successor information is stored and imported that. This gives me task lead and lag informatin as well as dependencies.</P><P>&nbsp;</P><P>I also need task constraint information - that is, whether tasks have Start No Earlier than, Finisish No Ealier than (etc) constraints, and if so, what the associated dates are.</P><P>&nbsp;</P><P>I have found nothing myself, and no search results match what I'm looking for. Has anyone managed to import this information into Power BI?</P> Wed, 13 Mar 2024 23:05:52 GMT https://community.fabric.microsoft.com/t5/Power-Query/Project-Online-task-constraint-information/m-p/3761825#M123797 Wellingtoon 2024-03-13T23:05:52Z https://community.fabric.microsoft.com/t5/Power-Query/Project-Online-task-constraint-information/m-p/3762742#M123821 <P><FONT>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="139754" data-lia-user-login="Wellingtoon" class="lia-mention lia-mention-user">Wellingtoon</a>&nbsp;,<BR /><BR />See if these samples and blogs are helpful.<BR /><A href="https://pwmather.wordpress.com/2013/08/01/projectserver-projectonline-highlight-report-example-ps2013-sp2013-excel-bi-office/" target="_blank">#ProjectServer #ProjectOnline highlight report example #PS2013 #SP2013 #Excel #BI #Office – Modern Work Management – Project and the Power Platform blog (wordpress.com)</A><BR /><A href="https://pwmather.wordpress.com/2013/09/16/projectserver-projectonline-example-report-ps2013-sp2013-office365-bi-excel-powerpivot/" target="_blank">#ProjectServer #ProjectOnline example report #PS2013 #SP2013 #Office365 #BI #Excel #PowerPivot – Modern Work Management – Project and the Power Platform blog (wordpress.com)</A><BR /><A href="https://pwmather.wordpress.com/2014/07/17/getting-started-with-projectonline-part-9-ps2013-office365-project-ppm-sharepointonline-pm-sp2013/#more-2022" target="_blank">Getting started with #ProjectOnline Part 9 #PS2013 #Office365 #Project #PPM #SharePointOnline #PM #SP2013 – Modern Work Management – Project and the Power Platform blog (wordpress.com)</A><BR /><A href="https://www.odata.org/documentation/odata-version-3-0/url-conventions/" target="_blank">URL Conventions (OData Version 3.0) · OData - the Best Way to REST</A><BR /><BR /></FONT></P> <P><FONT size="2">Best Regards,<BR />Gao</FONT><BR /><FONT size="2">Community Support Team</FONT></P> <P>&nbsp;</P> <P><FONT size="2">If there is any post<SPAN>&nbsp;</SPAN><FONT size="3" color="#008080"><EM><STRONG>helps</STRONG></EM></FONT>, then please consider<SPAN>&nbsp;</SPAN><FONT size="3"><FONT color="#008080"><EM><STRONG>Accept it as the solution</STRONG></EM></FONT><SPAN>&nbsp;&nbsp;</SPAN></FONT>to help the other members find it more quickly.<BR />If I misunderstand your needs or you still have problems on it, please feel free to let us know.<SPAN>&nbsp;</SPAN><FONT color="#008080"><EM><STRONG><FONT size="3">Thanks a lot!</FONT></STRONG></EM></FONT></FONT></P> <P><FONT size="2" color="#FF0000"><A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener nofollow noreferrer"><SPAN>How to get your questions answered quickly</SPAN></A><SPAN>&nbsp;--&nbsp;</SPAN><A href="https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank" rel="noopener nofollow noreferrer"><SPAN>&nbsp;</SPAN>How to provide sample data in the Power BI Forum</A>&nbsp;--&nbsp;<A href="https://community.fabric.microsoft.com/t5/China-Power-BI-User-Group/gh-p/ChinaPowerBIUserGroup" target="_blank" rel="noopener">China Power BI User Group</A></FONT></P> Thu, 14 Mar 2024 07:52:18 GMT https://community.fabric.microsoft.com/t5/Power-Query/Project-Online-task-constraint-information/m-p/3762742#M123821 Anonymous 2024-03-14T07:52:18Z