Forum Discussion
Different Schema in Testing and Production Database
Hi santhiya ,
So the idea is to already specify in your source query which of the columns you'd like to use. There are plenty of ways to do this, i.e. as explained before you create a view so you establish the query definition in the database. Otherwise, you could of course also just specify the columns you want in your query by writing an sql statement, for instance.
Here a source that might help you:
Import data from a database using native database query - Power Query | Microsoft Learn
If this does not help, please provide a screenshot of your M Power Query statement (advanced editor)
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Thanks tackytechtom , As I am not familiar with Power Query , can you please explain how this can be done with source query . Any articles related to this can help me to sort out . Thanks
Hi santhiya ,
So the idea is to already specify in your source query which of the columns you'd like to use. There are plenty of ways to do this, i.e. as explained before you create a view so you establish the query definition in the database. Otherwise, you could of course also just specify the columns you want in your query by writing an sql statement, for instance.
Here a source that might help you:
Import data from a database using native database query - Power Query | Microsoft Learn
If this does not help, please provide a screenshot of your M Power Query statement (advanced editor)
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/Thanks tackytechtom