Convert local folder datasource to Sharepoint folder

[Anonymous]

Hello,

Trying to convert a local folder datasource into a Sharepoint folder one.

See image attached.

Query at the top is using the same file from the SP folder.

Query at the bottom is using the same file from the local folder.

Though that just by replacing the first lines  - replace from 14 to 20 lines with lines from 1 to 9 - of the query would do it but for some reason I cannot understand the query is breaking.

I was trying to prevent from redoing the whole query all over again....

Can you please help me to understand why?

Thank you

J

[v-chuncz-msft]

@Anonymous,

Share us more detailed information, especially the error message.

[Anonymous]

@v-chuncz-msft

Getting this error message.

Expression.Error: The name 'Sample File' wasn't recognized.  Make sure it's spelled correctly.

pointing to this line of code

= Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File from Toggl (2)", Table.ColumnNames(#"Transform File from Toggl (2)"(#"Sample File")))

[MarcelBeug]

Refering to your other post it looks like you didn't just changed the source in 2 places, but you made copies (as I see sequence numbers in the names) and apparently mixing up the 2 copies.

As I suggested in the other post: go back to the working version and just change the source in 2 places.

Don't make copies.