Power BI is Pulling 4 sets of baseline data from PWA

[Anonymous]

Hi All,

I am having an issue with PWA integration, the connection is setup and working correctly so far but looking closer at the data I have 4 versions of the data coming into BI desktop:

You can see from the above screenshot that baseline number 0 for the same project name has 4 sets of data and this is causing massive confusion issues in Power BI.

Any ideas why this is happening please?

Thanks

Phil

[MFelix]

Hi @Anonymous ,

Have you tried making a group by using the base columns and the the sum of the rest of the values:

https://learn.microsoft.com/en-us/power-query/group-by

[Anonymous]

Hi,

No I didin't but the issues is that the additional lines are there at all, it seems that a number of baselines are being stored somewhere (dataverse?) Why are they ther and how do I cleanse them out?

If I just combine them that will also produce incorrect results.

Cheers

[MFelix]

Hi @Anonymous ,

Without specific information I cannot give you a correct explanation but based on the image ytou have share the task id are different so you have a line for each of the values

So for each task you have a line.

[Anonymous]

Hi @MFelix 

Trying to illustrate the problem, the above screenshot is from the same data, you can see I have the same activity names with very different info against the lines for the same activity. I am also having issues with some calculations coming from the baseline and it appears its adding up the lines... What other info would be useful to you to understand the issues please?

Thanks