Forum Discussion
Reload query to data model
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?
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!
1 Reply
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!