Conseils sur la façon d’identifier, de traiter et de résoudre les erreurs provenant de sources de données externes et de Power Query lorsque vous actualisez des données.

Advice on how to identify, deal with, and resolve errors from externals data sources and Power Query when you refresh data.

By default, automatic data type detection is enabled in Power Query for unstructured sources, but you can change the option setting. In some cases, you may not want these steps to automatically occur because the action might cause refresh errors of your data source.

When you create a formula, Power Query validates the formula syntax. However, when you insert, reorder, or delete an intermediate step in a query you might potentially break a query.

With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports.

Toutefois, il est judicieux de conserver les erreurs (en copiant la requête) en tant qu’outil d’audit pour identifier les lignes avec une erreur. Pour obtenir une description détaillée de la façon de gérer les erreurs, consultez Gestion des erreurs (docs.com).

When you create a new Excel workbook that contains queries, Power Query uses the current operating system locale as the default locale. This setting determines how Power Query interprets data imported from text, numeric, and date and time values.

In Power Query, if your query has rows with data errors, you can remove these rows from your query. Data errors can occur as a result of a query or step evaluation, such as changing the type of a column to Number that results in errors for some cells.

Vous pouvez rencontrer l’erreur suivante lorsque vous essayez d’ajouter ou de modifier une requête Microsoft dans Excel : Erreur : « Microsoft Query n’a pas pu être démarré, car elle n’est pas installée.

If you notice that loading a query to a Data Model takes much longer than loading to a worksheet, check your Power Query steps to see if you are filtering a text column or a List structured column by using a Contains operator.