Forum Discussion

Mastermayank26's avatar
Mastermayank26
Microsoft Employee
1 year ago
Solved

Copilot response not correct

I've recently started integrating Copilot with my data using the "Prep data for AI" feature. While Copilot generally provides accurate responses when it performs its own calculations, it occasionally pulls answers from existing report visuals, which can be incorrect.

Is there a way to disable this behavior so that Copilot does not reference any visuals in the report and instead always calculates responses based on the formulas provided by the developer?

 

Tips and Tricks
  • SamsonTruong's avatar
    SamsonTruong
    1 year ago

    Hi Mastermayank26 ,

    The "Prep data for AI" feature is awesome and I have personally not had this use case. However, one workaround I believe may work is to add AI instructions within the "Prep data for AI" feature telling Copilot to not reference existing visuals in the report.

    Here is some documentation around the AI instructions feature: https://learn.microsoft.com/en-us/power-bi/create-reports/copilot-prepare-data-ai-instructions

    If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

    Thanks,

    Samson

     

    Connect with me on LinkedIn

    Check out my Blog

    Going to the European Microsoft Fabric Community Conference? Check out my Session

7 Replies

  • SamsonTruong's avatar
    SamsonTruong
    Super User
    1 year ago

    Hi Mastermayank26 ,

    The "Prep data for AI" feature is awesome and I have personally not had this use case. However, one workaround I believe may work is to add AI instructions within the "Prep data for AI" feature telling Copilot to not reference existing visuals in the report.

    Here is some documentation around the AI instructions feature: https://learn.microsoft.com/en-us/power-bi/create-reports/copilot-prepare-data-ai-instructions

    If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

    Thanks,

    Samson

     

    Connect with me on LinkedIn

    Check out my Blog

    Going to the European Microsoft Fabric Community Conference? Check out my Session

  • Akash_Varuna's avatar
    Akash_Varuna
    Super User
    1 year ago

    Hi Mastermayank26 I don’t think it’s possible to fully restrict Copilot from referencing report visuals. However, one way to improve accuracy is by crafting better prompts that specify Copilot should calculate answers directly using the dataset or formulas. 

  • arvindsingh802's avatar
    arvindsingh802
    Community Champion
    1 year ago

    Mastermayank26  - you can limit Copilot search by configuring the AI instructions as mentioned by SamsonTruong , I am using this and its working in most of cases, there are few limitations but still happy with this new feature.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    Hi Mastermayank26  ,
    Thanks for reaching out to the Microsoft fabric community forum.

    There is no explicit feature to disable the behaviour you are experiencing, please try refining your instructions using prompt engineering techniques to guide the system's behavior more effectively. This can help ensure that the responses align with your expectations and may prevent the underlying issue from reoccurring. By crafting more specific and structured prompts, you may be able to influence how the system interprets and executes your requests.

     



    If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
    Thank you

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    Hi Mastermayank26 

    May I ask if the responses have helped you? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

     

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    Hi Mastermayank26 

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


    Thank you.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    Hi Mastermayank26 

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Thanks and regards