NEW! FREE 90 Minutes Excel VBA Course for Beginners! Watch now 

Power BITutorials

Disable Relationship Detection for Beginners in Power Query

1 Mins read
UNCHECK RELATIONSHIPS OPTION

Disable Relationship Detection for Beginners in Power Query. This is another feature of Power Query that will speed up your queries. When you load your data into the data model from the power query, Excel will try to find and build relationships between the new data and other tables in the present in the data model. Thus, it will take extra processing time and will slow down your queries. All these steps are prepared by our Power Query Training Experts.

Disable Relationship Detection With Power Query

If you are always loading your data into the data model, then you should turn this feature off in order to save time. Below are the steps to disable relationship detection.

Step 1: Open Query options

Go to the File menu and then press the Options and Settings button and open the  Options.

OPEN QUERY OPTIONS

Step 2: Uncheck Relationships Option

In the Current File Data Load settings, uncheck the ‘Autodetect new relationships after data is loaded’ option. This will prevent Excel from creating relationships between tables in the data model.UNCHECK RELATIONSHIPS OPTION

You can learn more:

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…