Reload query to data model

[domtrump]

If I accidently loaded my query to a TABLE rather than the Datamodel, how can I go back and change it to "Only Create Connection" and "Load to DataModel"? Am I able to change this? "Load To" is now greyed out. Only way I have found so far is to delete the query and reload it the correct way. Ideas?

[Anonymous · Accepted solution]

Hi @domtrump 

Yes, you can change the settings. Instead of changing the Close & Load options within Power Query, we can view them in the Queries and Connection pane. In Excel, click Data > Queries & Connections. From the list of queries, right-click on the query and select Load To…

To learn more about the setting options, you can read the article: Get to know Power Query Close & Load options - Excel Off The Grid

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!