Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have an issue in reporting from project online via pwoer bi,
the projects have more than one baseline whihc cause to have duplication in project Id like this as number of baseline is showing in another column. that should be duplicated as many other columns have differernt value in one project Id.
when I refresh it, I see this error and I tried to change relationships many time, but non of them worked. also, I deactive relationships or disbale to load the table, I see still the error, can anyone helpe me?
I need to have the basline numbers in my reporting.
Hi @Archie-gh ,
You can try the following methods:
1. Remove duplicate rows in Power Query and try again.
2. Remove all these unnecessary created relationships, and also turn off the "Auto-detect relationship" function
https://radacad.com/power-bi-design-tip-disable-the-auto-detect-relationship
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Are u using a single table or multiple tables for this project? If ur TaskBaselines is a separate table then first find a unique id for baseline number. Or u can use remove duplicates in transformation data.
@Archie-gh , Change relation to many to many or remove that.
Also, validate in the property pane of the Data model view, By selecting this table. Is projected marked as the key column, if yes set it none
Hi Amitchan
that doesn't work,
key column is like this
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |