Switching Connectors in Power Query: A Simple Guide

TLDRLearn how to switch connectors in Power Query without rebuilding your query from scratch. Make changes to the M code at the start of the query to accommodate new data sources. This video provides a step-by-step tutorial on switching connectors.

Key insights

🔀Organizational IT systems evolve over time, requiring changes to connectors in Power Query.

🔄Changing connectors does not mean rebuilding the entire query; only adjustments to the M code are necessary.

💾Creating a backup of the original query is essential in case any changes go wrong.

📝Identifying the switch point, where the new connector can be integrated into the query, is crucial.

Testing the new connector ensures that the query continues to function properly.

Q&A

Is switching connectors in Power Query complicated?

Switching connectors can seem daunting at first, but by following a structured approach like the one shown in this video, it becomes manageable.

Do I need to rebuild the entire query when changing connectors?

No, you only need to make changes to the M code at the start of the query, leaving the rest of the query intact.

What is the switch point?

The switch point is the earliest point in the query where the new connector can be used without changing the subsequent steps.

Why is creating a backup of the original query important?

Creating a backup ensures that you have a copy of the original query in case any changes to the M code cause issues.

How can I test the new connector before implementing it?

You can create a new query using the new connector and compare the output with the original query to verify that everything is functioning correctly.

Timestamped Summary

00:00Organizational IT systems evolve, necessitating changes to connectors in Power Query.

03:49Create a backup of the original query to ensure you can revert back if needed.

06:12Identify the switch point, where the new connector can be integrated into the query.

08:00Make changes to the M code at the start of the query for the new connector.

08:42Test the new connector by comparing the output with the original query to ensure everything is functioning correctly.