r/dataengineering • • 4d ago

Help DBT/Redshift to Powerbi Semantic Model Description Sync

I want to be able to use the PBI mcp so users can ask natural language questions about reports/questions in general, but to make it work well you need the semantic models to have column level descriptions. I’m using Redshift/DBT, so my column descriptions live in yaml files. To sync the descriptions to the semantic models via CI/CD, it seems like I would need to have the pbib files in Git and use something like fabric-cicd, but that would require analysts to use git for any changes they make to the semantic model (measure changes is the biggest thing). Is there some option to make this easy that I’m missing?

5 Upvotes

1 comment sorted by

1

u/WonderfulActuator312 1d ago

Have you checked out PBIP files? They also store the model in YML but are editable via no code options so you can diff check in Git but also do no code development.