You can use this C# script in Tabular Editor to achieve this. Basically, all the comments can be accessed via the 'information_schema' in Databricks. Import the relevant columns from the schema using this query
select * from samples.information_schema.columns
You will only need the tablename, columnname, comment columns (you will need a mapping table to map the view name from databricks to the table name in Power BI).
This is a once off step. Then just run the below script and you're done !
