Power Query issues after initial run of the query
A connection only query will not refresh unless there is another query that is dependent on it. If you want to refresh it, you must change it to output to the workbook or to the power pivot data model.
In Excel, use Data>Queries & Connections. Right-click the query you want to refresh and choose Load To
Select an appropriate destination for your query results.
You may want to choose 'Table':
With regards to the "replication problem", it's a little difficult to say without seeing:
- your connections properties window and
- the full text of the Advanced Editor in the Power Query Editor window
You should probably experiment with different settings in the connections properties window. Use Data>Queries & Connections>Properties to show the window in the image below, then try refreshing your query under different options.
