Wrong baseline showing up in PowerBI table from PWA

[ChrisUTE]

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.

Wrong Baseline Graphic on Power BI

Correct Baseline Graphic on Power BI 

Excel Sum 

Project Pro Baseline Cost (correct)

PWA Baseline Cost (correct) 

[V-lianl-msft · Accepted 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.