Refresh error

anamika · ‎04-15-2020

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 · ‎04-15-2020

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,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anamika · ‎04-15-2020

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 · ‎04-17-2020

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,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.