Forum Discussion
Solved
Pointing data to SharePoint folder instead of a local data source (OneDrive)
We have a user who created a whole PowerBI flow via a connection to data located within their OneDrive for Business folder on their C:\ instead of pointing the data to a Teams SharePoint source where...
You will have to swap out the first 1-3 lines of each query. You cannot change it using the datasource button. That only changes locations with the existing connector, not changing connectors.
I've done this before, and it is tedious, but doable.
Hi JMACND
As edhans says you have to change the first few lines of each query to point to the new source location, but once you've done that, and perhaps one or two other lines to make sure you end up with the same table that is then used for the transformations in the query. None of the transform steps should need adjusting.
Regards
Phil
