Forum Discussion
Power BI showing impartial join
Hi,
For the purpose of being concise and brief, I will share an example of the problem I am facing.
I have a table called "KPI" with columns KPI_ID, KPI_Name.
I have another table for plans called "Total Plans" where I have a column for KPI ID and Plans.
In SSAS, I have created a relationship between the two IDs. The problem that arises is as follows. Let's say there are IDs present from 1-5 with their respective KPI names.
In power BI when pulling up plans for KPI names, I can only see plans for IDs 1-3 and not 4,5. Also when I view the table for Total Plans. KPIID I can see plans for all IDs ie. 1-5.
Also, when I create a calculated column KPIKey in Total Plans, I can see IDs 4,5.
KPIKey = Related(KPI[KPI_ID])
What could be the reason for this impartial join that is reflecting in Power BI but not SSAS
1 Reply
- v-jiascu-msftMicrosoft Employee
Hi Vikram_Thukral,
1. Do both tables have the data of 4 and 5?
2. Can you share the file?
3. How did you pull up plans for KPI names? In a table visual?
Best Regards,
Dale