Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Copilot Pane Behavior and Linguistic Model in Direct Lake Mode

Scenario
to utilize the new Preview feature, Live edit Power BI semantic models’ semantics in direct lake mode using for following links:

  1. Live Edit of Direct Lake Models in Power BI Desktop (October 15, 2024)

https://powerbi.microsoft.com/en-us/blog/live-edit-of-direct-lake-models-in-power-bi-desktop/

  1. Get the Most Out of Power BI Copilot (October 17, 2024)

https://www.linkedin.com/pulse/get-most-out-power-bi-copilot-improving-responses-direct-pecile-hrb3c...

  1. Direct Lake in Power BI Desktop (September 25, 2024)

https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-power-bi-desktop

After enabling the feature and signing in with proper right I Opened my Live edit Power BI semantic models semantics in direct lake mode,
from modeling tab >>> Logistic Model >>> Import YAML File
As the guides in above State

I applied 2 cases in YAML as:

  • Synonms: “cus”, “client” for dim_customer Table customer_name Column
  • Global Substitution: “GSTEST” for COOP – Odense row value of customer_name

Version: 4.1.0

Language: en-US

Entities:

  dim_customer.customer_name:

    Definition:

      Binding: {Table: Dim Customer, Column: Customer Name}

    State: Generated

    Terms:

    - customer name: {State: Generated}

    - cus: {State: Generated, Weight: 0.97}

    - client: {State: Generated, Weight: 0.97}

    NameType: Name

GlobalSubstitutions:

- COOP - Odense: GSTEST

 

Output

The Result in Copilot chat, it should recognize the synonyms and global substitution, in the YAML file
but upon checking the ADO Repo and BIM file 3 things are noticed:

  • The context of entities is not fully mapped, verified by visiting BIM file code
  • The Code of Global Substitutions appears in BIM file code, but they don’t work on Copilot Pane chat
  • Many entities are generated other than the scoped Entities, usually these entities are automatically added once you enable Q&A first time, all of them are garbage thesaurus and default synonyms content

What am I missing here?

And why Copilot is not capturing the global substitution through they are in BIM file
And why these Extra additions added to BIM file though they are not in the context of YAML file? 

Status: Investigating

Hi  @you5ufb,

 

The extra entities being generated could be due to the initial setup of the Q&A feature. When Q&A is enabled for the first time, it might automatically generate some default synonyms and content. You can manually clean these up if they are not relevant to your model.

Please ensure that the entities in your YAML file are correctly defined and that the bindings are accurate. Double-check the table and column names to make sure they match exactly with what is in your model. The global substitutions should be recognized if they are correctly defined in the YAML file. Make sure that the syntax and format are correct.

 

Best regards.
Community Support Team_Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi  @you5ufb,

 

The extra entities being generated could be due to the initial setup of the Q&A feature. When Q&A is enabled for the first time, it might automatically generate some default synonyms and content. You can manually clean these up if they are not relevant to your model.

Please ensure that the entities in your YAML file are correctly defined and that the bindings are accurate. Double-check the table and column names to make sure they match exactly with what is in your model. The global substitutions should be recognized if they are correctly defined in the YAML file. Make sure that the syntax and format are correct.

 

Best regards.
Community Support Team_Caitlyn

you5ufb
Regular Visitor

Thanks, for replay @v-xiaoyan-msft 

Actually I checked BIM file before and after YAML import, YAML code is as you can see only this 2 entries, and as for BIM file it will be empty from Linguistic entities and Global Substitution at first, once my YAML imported. 
regardless of my code these many entities are generated, and also I can see Global Substitution section with my change, but Copilot pane does not recognize the term.
it feels like the behavior is rather a bug
My main Issue is a way around to apply Global Substitution to a Default Lakehouse Semantic Model in Direct Lake Mode, as I practiced the activity in other mode with the YAML and it seems working there