Forum Discussion

domtrump's avatar
domtrump
Helper II
2 years ago
Solved

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 g...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!