This is another feature of Power Query that will speed up your queries. When you load your data into the data model from 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.
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.
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 the relationships between tables in the data model.
You can learn more:
- Create A Sequential List in Power Query
- Learn How to Navigate Query Editor in Excel
- Learn How to Split Queries In Power Query
- Editing A Query in Excel