How to make PowerBI Copilot Work

[davidpc]

Hi there!

I'm trying to use Copilot for Power BI (standalone version) with a star-schema modeled dataset, following best practices in dimensional modeling. I've prepared the data specifically for AI consumption by simplifying the schema and creating a Markdown-based AI instruction that outlines the tables, measures, and relevant business context. However, when I ask Copilot questions about the data, some responses reference incorrect metrics or misinterpret variables.

Could someone explain a reliable way to structure AI instructions to improve accuracy? Is there a method to enrich the semantic model so that synonyms are better recognized and mapped—beyond what’s currently defined in the Markdown instructions?

Thanks!

[v-menakakota]

Hi @davidpc  , 

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank  @audreygerred  and @ibarrau , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 

• As mentioned above, it’s worth reviewing the official “Optimize your semantic model for Copilot” guidance since it covers naming conventions, synonyms, and metadata enrichment that help Copilot better understand your model.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.   
Best Regards, 
Community Support Team  

[audreygerred · Accepted solution]

Hello! In addition to star schema, please ensure you are following the rest of the guidance in this article: Optimize your semantic model for Copilot in Power BI - Power BI | Microsoft Learn

Prepare your data for AI - Power BI | Microsoft Learn

[ibarrau]

Hi. I think the purpuse of copilot is assisting you when developing. If you want an IA to ask questions about that, then the resource would be Fabric Data Agents. The agents let you configure different type of instructions and even query examples to a lakehouse.

Theoretical difference: https://learn.microsoft.com/en-us/fabric/data-science/concept-data-agent#difference-between-a-fabric...

I hope that make sense