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.
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
Hi @Phild2h ,
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi,
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
Hi @Phild2h ,
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
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 |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |