Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Import SQL server synonyms

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

  • 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

1 Reply

  • 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