Forum Discussion
How to switch data source from .csv to SQL
Hello I am having issue changing data source that currently references a csv file to a SQL list. I tried to change the source out but it is giving issues in telling me that I am missing fields. ...
Hi cinsbox ,
Based on the error message, please firstly only write the SQL source code"let Source = Sql.Database........in Source" in a blank query and check if the result contains a column named "Gift ID". If not, the error occured because the following steps refering a column "Gift ID" but not exist in the previous step. Then you can tweak the formula like change the column name etc. in the Advanced editor.
What's more, in Power Query, if an error occurs, you can find the first step which has an error in Applied steps, the error must happen in this step.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Community Support Team_yanjiang