Forum Discussion
Helper IVUpdating existing SharePoint Connection to V2
I assume v1 and v2 are returning different columns, so you are getting downstream errors. Instead of rebuilding your queries, you can do the following:
- make a new query with the v2 connector
- do any steps to get the data looking just like one of the steps in your original query
- copy the new steps from the Advanced Editor and paste them over the first steps of your existing query (updating any references between steps)
- Delete the new query you copied the new M code from.
With this approach, it is the original query that is still loading, and you won't have to re-make your relationships either.
Pat
Microsoft EmployeeI assume v1 and v2 are returning different columns, so you are getting downstream errors. Instead of rebuilding your queries, you can do the following:
- make a new query with the v2 connector
- do any steps to get the data looking just like one of the steps in your original query
- copy the new steps from the Advanced Editor and paste them over the first steps of your existing query (updating any references between steps)
- Delete the new query you copied the new M code from.
With this approach, it is the original query that is still loading, and you won't have to re-make your relationships either.
Pat
Helper IVmahoneypat Thank you.
I will try out that method. I did discover a couple of other items that could be affecting the refresh but I certainly want to update the connection. As you suspected, some column information is mismatching now,
so there is some effort there in the schema.
Thanks again,
Trent