SSAS MD Live Connection Error in Columns

[Thiyagu]

Hi All,

I have connected my PBI report with SSAS MD live connection. When i drag a column (Ex: Column1) from a table in table visual, the values shown perfectly. When i drag the same kind of column from another table which has less number of records than column 1 it show error.. I dont know what cause this and i cant explain to my customers without knowing the reason behind. 

If there is no solution for this, atleast i want to know the reason behind it..

Note : i can able to drag both fields in excel and it works perfectly

 @Greg_Deckler@v-shex-msft@v-qiuyu-msft@Baskar@v-yuezhe-msft

[v-chuncz-msft]

@Thiyagu,

You may first check the relationships in Power BI Desktop.

[Thiyagu]

Hi @v-chuncz-msft

Thanks for the response.

I'm using SSAS MD live connection.. Is there relationship issue?

Thanks

[Thiyagu]

Hi Anyone..

Is there any solution?

Thanks