cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Wrong baseline showing up in PowerBI table from PWA

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 BIWrong Baseline Graphic on Power BI

 

Correct Baseline Graphic on Power BICorrect Baseline Graphic on Power BI 

 

Excel SumExcel Sum 

 

Project Pro Baseline Cost (correct)Project Pro Baseline Cost (correct)

 

 

 

PWA Baseline Cost (correct)PWA Baseline Cost (correct) 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Wrong baseline showing up in PowerBI table from PWA

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.

View solution in original post

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Wrong baseline showing up in PowerBI table from PWA

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.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors