Skip to main content

Power BI

New

Disable autodetect of relationships.

Vote (44) Share
drsmith's profile image

drsmith on 09 Jul 2015 05:54:43

Option to Disable Autodetect of relationships on data refresh.
Option to Disable Autodetect of relationships on the addition of a new table.
Option to Disable Autodetect of relationships in all situations.

Comments (6)
drsmith's profile image Profile Picture

a8b729fb 2a42-4efe-be4a-dd6f9b05e6c9 on 06 Jul 2020 00:14:57

RE: Disable autodetect of relationships.

Just spend a decent amount of time trying to work out why a report wasn't displaying as intended and it was down to this, it should be a global level option

drsmith's profile image Profile Picture

0074d8fc eba5-4dcc-96de-4d3c3109aff7 on 06 Jul 2020 00:14:33

RE: Disable autodetect of relationships.

Please have a global setting and make the default off. Then in the model view add a button - “Detect relationships “

drsmith's profile image Profile Picture

65a70ab4 ead3-4b2d-8a77-4b6c3116bbcc on 06 Jul 2020 00:03:38

RE: Disable autodetect of relationships.

Put this in the global settings so it's saved as default.

drsmith's profile image Profile Picture

4615599e feea-417f-ade1-50007924402c on 05 Jul 2020 23:20:58

RE: Disable autodetect of relationships.

This slows large data sets substantially

drsmith's profile image Profile Picture

355a81e2 0dac-47d2-a1b9-e63ff15e5227 on 05 Jul 2020 23:17:42

RE: Disable autodetect of relationships.

There is currently an option to turn this of at the report level. But I think it should be an option to turn it off by default completely. It is just not a useful feature - it creates more false/incorrect relationships than correct ones, and having to turn this off in each new blank workbook is not workable.

drsmith's profile image Profile Picture

d9864544 f7d1-46eb-8615-7cdfbf41b42c on 05 Jul 2020 22:08:38

RE: Disable autodetect of relationships.

Please do this! Auto relationships break visualizations and create relationships where there is no logical relationship.