Forum Discussion

dgwilson's avatar
dgwilson
Resolver III
24 days ago
Solved

CoPilot - Prep Data for AI

Hi there...

 

I've got a confusing issue where I have Copilot access (via Power Bi Desktop) but prep Data for AI says I do not have access.

The reports I'm updating - I'm not the original author of. This is happening in two reports now and I'm sure I've done it successfully in one of the. The error message should be updated to provide stacks of addmitional information in my opinion as this is insufficient for diagnosis.

Any pointers appreciated.

Version: 2.156.951.0 64-bit (July 2026)

 

 

  • Hi dgwilson,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you MohamedFowzan1Natarajan_MGautam_Kumar01 and danextian for the prompt response.

     

    Here the Prep data for AI does not save to the report, it saves to the underlying semantic model, so it checks your permission on the model itself. Please follow below:

    • You need write or build permission on the semantic model the report is built on, not just access to the report.
    • Q&A must be enabled on that semantic model.
    • In power bi desktop, Prep data for AI only works when the report uses an Import, DirectQuery or Composite(local) connection. If it is a live connection to a shared or published model, it will not work in desktop, instead author it in the service directly on the semantic model.

    For reference, follow the below documentation:

    Prepare Your Data for AI to Improve Copilot Results (Preview) - Power BI | Microsoft Learn

     

    Thanks and regards,

    Anjan Kumar Chippa

     

     

10 Replies

  • Hi dgwilson 

    Since this only happens on reports you didn't author, I'd test whether it's tied to report ownership. Try creating a new report (or Save As a copy) against the same semantic model and see if Prep data for AI works there. If it does, that points to a permissions/ownership requirement rather than Copilot itself. The current error message doesn't really help identify what's missing.

  • Hi dgwilson , Can you share the details of the file that you have opened in the desktop , is it connected live to the semantic model ? or its a file that have all the sources in it ? 

    Thanks 

    Thanks!

    Natarajan Manivasagan

    If you found this helpful, please consider giving it a Kudos and marking it as the accepted solution β€” it goes a long way in helping others facing the same issue.

     

    πŸ† Best Solution for Enterprise BI β€” 2026 Microsoft Fabric Semantic Link Developer Experience Challenge
    πŸ‘‰ Microsoft announcement Β· View the winning notebook

     

    For more Power BI tips and discussions, let's connect on LinkedIn.

     

    Cheers!

    • dgwilson's avatar
      dgwilson
      Resolver III

      OK, I have an update.

      The report is a thick report.

       

      When I was trying to do this setup I was working from home using my work issued Windows laptop. I did end up removing some proxy confiuration ...  and got it to work - that is less than ideal.
      From windows cmd line - setx https_proxy and setx http_proxy.

      As of writing this message - I am in the office and have loaded up the report I was having issues with and was able to access "Prep Data for AI" straight away.

      This to me means there is some network call that is failing and then falling through to some generic error message - that is of no help what so ever to allow any sensible diagnostics to be performed. And it's difficult for me to engage the network team when I can't tell them anything about what is happening.

       

      - David

  • Hi dgwilson 

     

    This happens because "Prep Data for AI" in Copilot requires tenant-level enablement + specific permissions, even if you have Copilot access in PBI Desktop.

     

    Here are the 3 things to check:

    1. Tenant Admin Setting
    Fabric Admin Portal > Tenant settings > Copilot > "Users can use Copilot and other AI features" must be ON
    Also enable: "Prep Data for AI" / "Copilot in Power BI" for your org

     

    2. Report Ownership / Permissions
    "Prep Data for AI" only works if you are the Owner or have "Reshare + Build" permission on the semantic model.
    Since you said "not the original author", ask the owner to give you Build permission on the dataset.

     

    3. License
    You need Fabric Free / Pro / Premium Per User + Copilot for Fabric license assigned to you.

    The error "You don't have access to Copilot" in that pane specifically means point 2. Desktop Copilot works but Model-level AI doesn't.

     

    Try: Open the semantic model > Manage permissions > Add yourself with Build. Then reopen report.

    Hope this helps!

    • dgwilson's avatar
      dgwilson
      Resolver III

      Take a look at my follow up message - where I said I tried this in the office and it worked.

      Thus the fault is a networking error of some description - though the error message doesn't provide any clues.

      Now, while I'm not the original author (they have left the business)... I have published this to a test workspace. Completed refreshes etc. So I'm the effective owner. I'm workspace Admin as well.

      Plus tenant admin - settings have not been reconfigured. And it's proof that all is OK in the office.

  • Co-pilot for Power BI requires a workspace with a premium or at least F64 capacity.  This feature also must be enabled by your tenant admin.

  • v-achippa's avatar
    v-achippa
    Community Support

    Hi dgwilson,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you MohamedFowzan1Natarajan_MGautam_Kumar01 and danextian for the prompt response.

     

    Here the Prep data for AI does not save to the report, it saves to the underlying semantic model, so it checks your permission on the model itself. Please follow below:

    • You need write or build permission on the semantic model the report is built on, not just access to the report.
    • Q&A must be enabled on that semantic model.
    • In power bi desktop, Prep data for AI only works when the report uses an Import, DirectQuery or Composite(local) connection. If it is a live connection to a shared or published model, it will not work in desktop, instead author it in the service directly on the semantic model.

    For reference, follow the below documentation:

    Prepare Your Data for AI to Improve Copilot Results (Preview) - Power BI | Microsoft Learn

     

    Thanks and regards,

    Anjan Kumar Chippa

     

     

    • v-achippa's avatar
      v-achippa
      Community Support

      Hi dgwilson,

       

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked?  or let us know if you need any further assistance.

       

      Thanks and regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Community Support

        Hi @dgwilson,

         

        We wanted to kindly follow up to check if the solution I have provided for the issue worked?  or let us know if you need any further assistance.

         

        Thanks and regards,

        Anjan Kumar Chippa

  • Please note. I have not accepted the solution proposed as I never agreed with it. Someone has accepted it without my input. I do not believe the "solution" above proposed is/was the fault in my case as access varies depending on in office or at home and or proxy settings and or VPN settings. The last two of which are outside of my control.

    None of the proposed BUILD access or Q&A enabled applies as thing swork in office - so I have the appropriate access. Hence I DO NOT AGREE with what someone has accepted as the solution.

    Accepting solutions in this way degrades the value to the community when searching for answers here.