Possible solutions: There are multiple solutions for this case, but they all depend on what you'd like to do. It displays the error shown in the following image. Power Query is unable to find a column heading named Column, so it can't rename any columns. But there was a change in the original text file, and it no longer has a column heading with the name Column because it was manually changed to Date. In your query, you have a step that renames that column to Date. This error is commonly triggered when a step makes a direct reference to a column name that doesn't exist in the query.Įxample: You have a query from a text file where one of the column names was Column. If the Edit settings button is available in the error pane, you can select it and change the file path. As user B, you can change the file path to be a local copy of the same text file. Possible solutions: You can change the file path of the text file to a path that both users have access to. When this person tries to execute the query, they get a DataSource.Error because there's no drive D in their environment. User A shares the query with user B, who doesn't have access to drive D. This error commonly occurs when the data source is inaccessible by the user, the user doesn't have the correct credentials to access the data source, or the source has been moved to a different place.Įxample: You have a query from a text tile that was located in drive D and created by user A. You can select the Go to error button, if available, to view the first step where the error occurred. In all cases, we recommend that you take a close look at the error reason, error message, and error detail to understand what's causing the error. In the example above, the error detail is Column. Error detail: The section directly after the Details: string.In the example above, the error message is The column 'Column' of the table wasn't found. Error message: The section directly after the reason.In the example above, the error reason is Expression.Error. Error reason: The first section before the colon.Step-level errorĪ step-level error prevents the query from loading and displays the error components in a yellow pane. This article provides suggestions for how to fix the most common errors you might find at each level, and describes the error reason, error message, and error detail for each. In Power Query, you can encounter two types of errors:
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |