Change AAS source database in Power BI composite model ( AAS and SQL server)

[AutreSolutionBI]

Goal: Use Power BI direct query mode to get data from Azure analysis service and Azure sql databse, and be able to change AAS database from dev to QA. 

I have etablished connexion for both source (see image 1) but when I tried to change AAS Database (ex.from DEV to QA  ), I got the error (see image 2) .

1-Change AAS connexion from Power BI Source setting

2-error image: 

Thanks

If Power BI is connected only with AAS in live mode I cange database without any problem. But it does not work after adding another data source (ex. Azure sql databse in this case).

[v-eqin-msft]

Hi @AutreSolutionBI ,

According to the error message,the main reason seems to be the wrong active relationship.

Generally speaking, there can only be one active relationship between two tables. If there is more than one relationship, it needs to be set as an inactive relationship. In addition, specific screening directions may also cause errors. For more information, please take a look at the official document:Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

Solutions provided from a similar thread:

1. turn off bidirectional cross filtering on all your tables.

2. Hide the foreign key in every data table. This way users won't accidentally use is instead of the primary key in the lookup table. 

3. When (and only when) you need a bi directional relationship for what you are doing, turn it on for that single table. 

4. If you ever need 2 that conflict, then use the many to many pattern. Refer to here https://www.powerpivotpro.com/2014/08/filters-can-flow-up-hill-via-formulas-that-is/ and also here http://exceleratorbi.com.au/many-many-relationships-dax-explained/

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.