Forum Discussion
Problem publishing after changing data source from local folder to SharePoint folder
In the Data source settings check that you don't have any leftover local sources.
Data source settings always retain what was initially set up regardless of whether you change the M code to use some other data source. M code uses sharepoint.files but Data Source Settings dialog window still says folder path. But it's indeed using the sharepoint location. Changine the M code does not appear to reflect in the data source settings.
That is incorrect, at least for "Data sources in this file". Go through all of your queries - one of them must still reference a local source.
They are all leftover data sources pointing to local paths. But like I mentioned, I updated the code to point them all to sharepoint folders. Problem is, the original data source settings don't change to reflect the redirection in the M code. So that's where I'm stuck. I can't find any way to change those original data source settings. It all works great using new SharePoint folder paths but the settings still say folder paths. And I don't want to have to delete the queries and build new ones just to please the pro service when I publish.
