Automatically create Dataverse tables with AI

Written on

11 July 2025

Richard Wierenga

Power Platform Lead

No matter what solution you're building, you'll always have space to store your data. In theory, that's simple. In practice, you can easily spend half a day clicking to create tables, columns and relationships in Dataverse. It's a situation that every Power Platform consultant recognizes: you have a nice diagram of your data model, you know exactly how everything works together... and yet you're endlessly entering fields manually. Especially when you work on projects where the data layer does not consist of one table, but of a complete network of entities that connect to each other.

Copilot's (limited) promise

When Copilot appeared for Dataverse, it seemed like Columbus' egg for a moment. Just describe your tables in plain language, and hop — done. But if, like us, you build more complex models — such as dynamic questionnaires that are linked to contacts, customers and answers — it quickly becomes clear that you still need to correct a lot.

Column names are wrong, relationships are missing, or you get generic tables that are of little use to you. In short: Copilot makes a lot of things, but often not what you need.

From diagram to reality

Since we start with a Mermaid diagram of our data model in almost every project, we asked ourselves: why not use that diagram as a basis? We already have that description anyway. So instead of first drawing and then knocking everything back in, we wanted to translate that into Dataverse in one go.

After a lot of puzzling (and many more prompts), I created a tool that does just that:

🛠️ Reads Mermaid charts with the structure of your tables and relationships
⚙️ Creates tables and columns in Dataverse
🔗 Captures one-to-many relationships immediately
📊 All without a manual click

The result: considerable time savings and much less error-prone work

What does it give?

In a recent project where we had to set up a dynamic questionnaire system, we normally spent hours creating all the tables: Questionnaires, Questions, Answers, the links with customer and contact details... Now it was done in fifteen minutes.

Of course, the tool is not finished yet. There are undoubtedly things that could be better. But the basics work: what you think out in your chart will appear as real tables in your environment a few minutes later.

AI-first in practice

This is a perfect example of how we at Blis Digital AI-first work. We're not using AI to replace people, but to make the real work — in this case thinking about data models and relationships — more interesting by removing the tedious manual steps. This way, we have more time for the things that are really important.

Try it for yourself

I put my tool online so that other Power Platform consultants can also experiment with it. For consultants who regularly create Dataverse tables, this can save hours of work.

Curious about my tool? You can find the first version in GitHub. And do you want to know more about how Blis Digital AI-First works? Then contact us.