Forum Discussion
Wrong Data in Power BI
Good Day
Using the above link, I found dublicated data that affected the graph that made the percentage of FMP adoption droped.
Find below there is a dublicated data entery and one of them assigned in the FMP but the percentage dropped, can you investigate what happened.
| 1006062243 | 63451cd58444a63cd69d4bbf | 1006062243 | COMP | COMP | MPF34212A0843-1006062243 | MAXIMO | yazrak | MPF-342 | MPF34212A0843 | 10/11/2022 7:35:49 AM | SL-4 & DR's | d7930876-2208-47f7-85d1-5d1c49476bfe | 1 | 1 | System | 10/18/2022 11:00:09 |
| 1006055281 | 633eb4f0747d9e7c65ccfd3f | 1006055281 | COMP | COMP | NPS34307Y0957-1006055281 | MAXIMO | yazrak | NPS-343 | NPS34307Y0957 | 10/6/2022 10:58:56 AM | STEM-3 & DR's | 3b57aa88-8590-4bf6-9c64-bda903691950 | 1 | 1 | System | 10/16/2022 06:00:25 |
| 1006077892 | 634fe2edce7244ffcaf2e187 | 1006077892 | COMP | COMP | SPF24304Y0062-1006077892 | MAXIMO | yazrak | SPF-243 | SPF24304Y0062 | 10/19/2022 11:43:41 AM | check this Unit to move it to CRE | e7cf1f4a-f208-429a-8fdb-a054651487a4 | 1 | 1 | System | 10/19/2022 12:30:17 |
| 1006077971 | 634fea70f6501ab51dd0caa8 | 1006077971 | COMP | COMP | SPF24398Y0541-1006077971 | MAXIMO | aali142 | SPF-243 | SPF24398Y0541 | 10/19/2022 12:15:44 PM | need check the light and air bag | 1223a703-2e52-4de9-9b50-6b1013416ff0 | 1 | 1 | System | 10/20/2022 12:30:14 |
| 1006077971 | 634feffcce7244ffcaf2e1ba | 1006077971 | COMP | COMP | SPF24398Y0541-1006077971 | MAXIMO | aali142 | SPF-243 | SPF24398Y0541 | 10/19/2022 12:39:24 PM | need check the light and air bag | f35197a5-e43a-4507-a474-820bfc9707b8 | 1 | 1 | System | 10/20/2022 12:30:14 |
| 1006050011 | 633a9fcc7814be179eb43a83 | 1006050011 | COMP | COMP | SSF51112Y1167-1006050011 | MAXIMO | yazrak | SSF-511 | SSF51112Y1167 | 10/3/2022 8:39:40 AM | SL-4 & Spark Test Inspection | f692d660-4ae5-4c04-b2db-804e62258a88 | 1 | 1 | System | 10/03/2022 15:46:08 |
| 1006050004 | 633aa085f0121df836444e96 | 1006050004 | COMP | COMP | SSF51113D0091-1006050004 | MAXIMO | yazrak | SSF-511 | SSF51113D0091 | 10/3/2022 8:42:45 AM | SL-4 & DR's | 7b4cb8d6-bec0-422a-bb5f-b2e7cf31c6d9 | 1 | 1 | System | 10/03/2022 15:46:09 |
| 1006050017 | 633aa0c17814be179eb43a8c | 1006050017 | COMP | COMP | SSF51113Y0567-1006050017 | MAXIMO | yazrak | SSF-511 | SSF51113Y0567 | 10/3/2022 8:43:45 AM | SL-4 & DR's | 653aa75a-102d-46e6-822d-7a0ffc5841ae | 1 | 1 | System | 10/03/2022 15:46:10 |
| 1006050006 | 633aa05d7814be179eb43a87 | 1006050006 | COMP | COMP | SSF51115Z0133-1006050006 | MAXIMO | yazrak | SSF-511 | SSF51115Z0133 | 10/3/2022 8:42:05 AM | Spark Test Inspection | 5bc5184c-a345-4dcc-921a-a96082422cd1 | 1 | 1 | System | 10/03/2022 15:46:08 |
| 1006050655 | 633bdccef0121df83645099a | 1006050655 | COMP | COMP | SUS23506Y1012-1006050655 | MAXIMO | yazrak | SUS-235 | SUS23506Y1012 | 10/4/2022 7:12:14 AM | STEM-2 & DR's | 49b543b5-c662-4fb6-944c-3b8fdab83e95 | 1 | 1 | System | 10/04/2022 11:15:20 |
| 1006055494 | 633ecc488444a63cd69d38ae | 1006055494 | COMP | COMP | TUF32014D0736-1006055494 | MAXIMO | yazrak | TUF-320 | TUF32014D0736 | 10/6/2022 12:38:32 PM | STEM-3 & TRS Service Level X5 | dc6e1843-3e0a-482b-a00e-8c3d960bef15 | 1 | 1 | System | 10/16/2022 06:00:25 |
2 Replies
Hi Yazrak
The link you shared to us cannot be opened , because we don't have access to view it .
As for your dublicated data, does it display properly in Desktop ? From the information you have provided so far, we are unable to determine the cause of the problem . Can you provide a sample to help us better deal with the problem?
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi Alisa,regarding the issue it self it's withen SLB system the data got dublicated and 1 of them is showing in our system and the other one dose't, but the overall perforemece dropped due that error.
So my qustion is, can you delete the dublicated information showing in the table above so it will show the correct KPI?
Regards
