Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
My organization is pulling data from Project Web App (PWA) to Power BI to generate status reports on projects we currently have running. The issue we are running into falls under the Portfolio Costs page when looking at our baselines. In 2 out of 3 graphics, the baseline is correct, but in the graphic/table that shows COST HEALTH > PROJECT > COST TYPE is off and we can not figure out why. The baseline in both Project Professional and PWA match one another, as well as the previously mentioned 2 graphics, but we can not figure out for the life of us as to why the third graphic is wrong. When exporting the data to Excel, there is a column called Assignment Baseline Cost, which I can not find that table in any version of Project, as well as the fact that when summing that column, the total amount does not match any of the baselines in Power BI (both the correct and wrong numbers). Any help on the issue would be greatly appreciated. I've attached snippets as to my issue. Thank you.
Solved! Go to Solution.
Hi @ChrisUTE ,
You need to research the data for troubleshooting. It is recommended that you download pbix from the power bi service and open it from the desktop.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ChrisUTE ,
You need to research the data for troubleshooting. It is recommended that you download pbix from the power bi service and open it from the desktop.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |