The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi there all, I am facing an issue with data, Power Bi is getting data from MS Project, I get the same values multiple times for columns
Project Baseline Work, Project Actual Work, Project Duration Variance, and so on, it was supposed to show values for each individual resource that works for the project. The Projects table and the Resources tables share a connection through Resource time-phased data and not directly, I have changed some relationships from single to both yet I cannot change all since I get messages that say I am not allowed to do so. Many thanks to anyone who helps me
Solved! Go to Solution.
@Anonymous , Not very clear. But if you are facing any issue with one side of the table and power bi is not taking that as one side. Check the table does not have a blank value on the join column.
Second Create a table visual on Join key column and count of the Join key column. Sort Desc on the count and check there is no value greater than one. If there is any value, first fix that.
@Anonymous , Not very clear. But if you are facing any issue with one side of the table and power bi is not taking that as one side. Check the table does not have a blank value on the join column.
Second Create a table visual on Join key column and count of the Join key column. Sort Desc on the count and check there is no value greater than one. If there is any value, first fix that.
User | Count |
---|---|
83 | |
83 | |
37 | |
34 | |
32 |
User | Count |
---|---|
92 | |
79 | |
61 | |
51 | |
51 |