cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AutreSolutionBI
Regular Visitor

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

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

AutreSolutionBI_0-1635114480950.png

2-error image: 

AutreSolutionBI_1-1635115173179.png
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).

 

 

 

 

 

1 REPLY 1
Eyelyn9
Community Support
Community Support

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.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors