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

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
dgwilson
Resolver III
Resolver III

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)

dgwilson_0-1785452927986.png

 

 

8 REPLIES 8
v-achippa
Community Support
Community Support

Hi @dgwilson,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you @MohamedFowzan1@Natarajan_M@Gautam_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

 

 

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

danextian
Super User
Super User

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.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Gautam_Kumar01
Post Partisan
Post Partisan

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!

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.

Natarajan_M
Super User
Super User

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!

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

MohamedFowzan1
Solution Sage
Solution Sage

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.

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors