Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Change Google Sheet Source to Excel Source

The Power Query Source Step below queries a google sheet xls.  How do I change the Source Step to a local folder (same file) on my computer, ex ("C:\Users\Downloads\myfile.xls"), and keep & retain al...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    The simplest method is to create a new query to connect to the local Excel file first, then copy its first several steps code into the GoogleSheet query to replace the first Source step. Don't forget to add a comma at the end of the last step you pasted. 

    Sometimes the auto-generated "Changed Type" step doesn't change data types correctly, you may need to adjust its code, or remove it then change data types manually to make sure all columns have proper data types before the subsequent transformations. 

     

    Duplicate the Googlesheet query to perform the replacement in case that you lose everything. 

     

    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 Anonymous 

 

The simplest method is to create a new query to connect to the local Excel file first, then copy its first several steps code into the GoogleSheet query to replace the first Source step. Don't forget to add a comma at the end of the last step you pasted. 

Sometimes the auto-generated "Changed Type" step doesn't change data types correctly, you may need to adjust its code, or remove it then change data types manually to make sure all columns have proper data types before the subsequent transformations. 

 

Duplicate the Googlesheet query to perform the replacement in case that you lose everything. 

 

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