changing relationships in direct query affect data source?

[wpf_]

If i change the relationship in direct query, will I change the relationsihp in the data source?

[parry2k]

@wpf_ yes, the good data model is the core of Power BI, both in terms of scalability and performance.

[parry2k · Accepted solution]

@wpf_ not it will not remove at the data source, it will only remove in Power BI data model, go ahead and remove it.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[wpf_]

@parry2k Thanks.  Is this a common practice to change relationships in the data model to get the desired results?  

[parry2k]

@wpf_ what you mean? I guess you are saying changing relationship in Power BI data model, if that is the question, yes whatever you do in the backend it doesn't reflect in Power BI data model, you have to manage/update/add relationship in Power BI data model independent of how it is done in the backend.

Not sure if this is what your original question is?

[wpf_]

@parry2k I connected to dynamics data source through directquery mode.  I was not getting the results that i wanted and i saw that one of the relationships between two tables are not active.  I tried activating it but am getting this msg:

"You can't create a direct active relationsip between table1 and table2 because that would introduce ambiguity between table2 and table3.  To make tis relationship active, deactivate and delete one of the relationships between table2 and table3 first"

So i was wondering if i deactivate or remove a relationship from power bi, will that remove the relationship in the data source as well?

If the answer is no, then is it OK to modify relationships in the data model which can be different then the relationships set in the data source, just so that I can get the results i want?  Is this common practice?  Thanks.