Refresh error

[anamika]

I am facing an issue in power bi services where the source of the data is Analysis Service.

Here is the error message :

BID table is bridge table. As per error message I checked the relationship as well.But no problem with relationship.
Can anybody help me on that?

[v-lid-msft]

Hi @anamika ,

What is the connective mode you are using, Import or Connection Live? Does there are any change applied to the source data, such as the type of field ContractID? Does it work when connect this AS server from Power BI Desktop?

Best regards,

[anamika]

Hi @v-lid-msft,

It is live Connection.No I have not changed anything respect to ContractId. It is not working in Power bi desktop as well.

[v-lid-msft]

Hi @anamika ,

What it the relationship between the two tables, one to one , one to many or many to many? Will there a possible that the source data has duplicate values in the “one” side table?

Best regards,