Import SQL server synonyms

[IeuanG]

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

[BA_Pete · Accepted solution]

Hi @IeuanG ,

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