I want to connect PowerBI and pull DDL information like I can do with SQL server by using below query as an example
"select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='tableName'"
Is there a way to even put in excel, currently its not even possible to copy from page columns in the web editor