Solved: Import SQL server synonyms

Anonymous · ‎06-14-2023

Is it possible to import to SQL server synonyms? Currently only tables and views are showing as options.

BA_Pete · ‎06-19-2023

Hi @Anonymous ,

As far as I'm aware, if you can query something in SQL then you can import it into Power Query using the Native Query connection, for example:

Therefore, we can query sys.synonyms to get the information you need:

Pete

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

BA_Pete · ‎06-19-2023

Hi @Anonymous ,

As far as I'm aware, if you can query something in SQL then you can import it into Power Query using the Native Query connection, for example:

Therefore, we can query sys.synonyms to get the information you need:

Pete

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Import SQL server synonyms