Power BITutorials

Disable Relationship Detection for Beginners in Power Query

1 Mins read

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.

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

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

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…

Leave a Reply

Your email address will not be published.