I have a Power BI workspace and Semantic Model that I run for a group of report writers.
What I am looking to do is connect and synchronize data within a SQL table to populate/refresh the Definitions/Synonyms/meta data within my semantic Model and use the SQL source as a way to automatically populate information in the model.
I know there are ways to query semantic model meta data using DAX queries but I am unable to find any resources on connect pipes to that model for the purposes of synchronization.