Project web app- No up to date data via OData feed
Hi all, we are working with the project web app. The Data stored in the project web app is pulled via the OData feed connector into a PowerBI report. The project web app is hosted on https://company.sharepoint.com/sites/pwa, the data is pulled from https://company.sharepoint.com/sites/pwa/_api/projectdata. The connection and data refresh was working for months without an issue, last week I have added two enterprise custom fields in the PWA and made some changes to the Enterprise Global. When opening the enterprise global a cache limit error appeared in Project Desktop, which was resolved by deleting the cache. I had to do a forced check in of the enterprise global in the PWA settings. I also got an error when loading the "Tasks" table in Power BI, an issue with one of the newly added enterprise custom fields was reported. This issue just appeared once, seems now to be resolved. Since then, I have not gotten any up to data from the PWA via the OData feed into PowerBI. When looking directly in the PWA the data gets updated, but gets not submitted via the OData feed anymore, some "old" versoin of the data gets submitted, I can run the data refresh against the OData feed without any issue but returns only "old" data. I also have 2 "Project Save from Project Professional" jobs under "Manage queue jobs" with job type "Cancelled" which I cannot remove / cancel from the list. How can I solve this? Thanks in advanceJoin the Fabric Partner Community for this Week's Fabric Engineering Connection calls!
Are you a Microsoft Partnerthat is interested in data and analytics? Be sure to join us for this week's Fabric Engineering Connection call, now offered at two different times! š Tamer Farag will be joining both calls to discuss the latest and greatest related to partner offerings and updates, including certifications, Fabric Featured Partners, trainings, incentives, and more. The Fabric Engineering Connection call taking place Wednesday, January 15, from 8-9 am PST. The APAC Fabric Engineering Connection call taking place Thursday, January 16, from 1-2 am UTC/Wednesday, January 15, from 5-6 pm PST. This is your opportunity to learn more, ask questions, and provide feedback.To join the call, you must be a member of the Fabric Partner Community Teams channel.To join, complete the participation form athttps://aka.ms/JoinFabricPartnerCommunity. We can't wait to see you this week!
Join the Fabric Partner Community for this Week's Fabric Engineering Connection!
Join us this Wednesday, October 30, from 8-9 AM PT for the weekly partner community call, Fabric Engineering Connection!This week's call will feature presentations on Admin & Security from Varun Jain and Rick Xu, followed by Data Protection with Anton Fritz. The Fabric Engineering Connection is a weekly call held in the Fabric Partner Community Teams Channel exclusively for partners. Hear directly from Fabric product engineering teams about upcoming features, ask questions, and provide feedback. To join these calls (as well as watch recordings of previous calls), please join the Fabric Partner Community Teams Channel by completing the participation form athttps://aka.ms/JoinFabricPartnerCommunity.
Start reference date not refreshed in report
Hi Community, I've created a Power BI report based on data from Project online. I changed few dates for certain projects in Project online. When I refresh the data in PBI Report, all project dates update correctly except for one specific project, where the reference date still show the old value. Any suggestion would be appreciated. Dale_HowardMVPAllow me to mention you hereFabric Analyst in a Day (FAIAD) TTT for Partners: Register today!
Two Train the Trainer events have been scheduled for the following dates: Oct 30Fabric Analyst in a Day TTT - Americas Dec 13Fabric Analyst in a Day TTT - EMEA These sessions will be delivered by Pragmatic Works Training. Whether you are a new partner that wants to learn more about FAIAD, have additional trainers that you'd like to ramp up on FAIAD, or if you're an existing partner that wants a refresher, we encourage you to sign up today! Please note that all registrations start out in pending, and you should expect a confirmation within a few days. Thank you!Join the Fabric Partner Community for this Week's Fabric Engineering Connection!
Join us this Wednesday, September 11, from 8-9 AM PT for the weekly partner community call, Fabric Engineering Connection! This week's call will feature presentations on Data Warehouse and Business Intelligence from Joanna Podgoetsky, Sujata Narayana, and Amanda Rivera. The Fabric Engineering Connection is a weekly call held in the Fabric Partner Community Teams Channel exclusively for partners. Hear directly from Fabric product engineering teams about upcoming features, ask questions, and provide feedback. To join these calls (as well as watch recordings of previous calls), please join the Fabric Partner Community Teams Channel by completing the participation form athttps://aka.ms/JoinFabricPartnerCommunity.Join us for the FY25 Fabric Engineering Connection Kick Off Call!
Summer is officially over and fall is in the air. Though we are sad to see it go, we are also excited because this means our weekly partner community call, Fabric Engineering Connection, will begin again! Be sure to join us tomorrow, September 4, from 8-9 am PT asTamerFarag, Fabric Partner Ecosystem Lead,kicks off the new season of calls. He will present all the latest and greatest related to FabCon Europe, training and certifications, GTM resources, Solutions Partner designations, specializations, XIAD, Fabric Featured Partner, and more. This is a call you will not want to miss! The Fabric Engineering Connection is a weekly call held in the Fabric Partner Community Teams Channel exclusively for partners. Hear directly from Fabric product engineering teams about upcoming features, ask questions, and provide feedback. To join these calls (as well as watch recordings of previous calls), please join the Fabric Partner Community Teams Channel by completing the participation form athttps://aka.ms/JoinFabricPartnerCommunity.
ERROR 4819
SQL Server: 2019 ERROR (4819) -" Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violates a uniqueness constraint imposed by the target table. Sort order incorrect for the follow" We tested the exact same stored procedures on SQL2019 System A and everything worked as expected. But it gives errors when we test on the SQL SERVER 2019 System B. SQL Server A and SQL Server B are the same version, 2019 but something is causing these jobs to fail. Iām not sure what to do next. Any thoughts/suggestions would be greatly appreciated. Thanks.
How to surface Project Online resources added to a project but have no assignments in Power BI
In Project Online, we add resources from our enterprise resource pool to projects using the "build team" functionality. Once the team is built for a project we may or may not assign some or all of those resources to tasks in the project. I want to create a Power BI report that shows all of the resources on a project team regardless of whether they have assignments or not. I can get the resources that have assignments, but I cannot figure out how to surface the resources that are on the project team but do not have assignments.
