Can't edit my direct queries in power bi desktop

[jimbobobwalker]

As of today 9/16/2025 i suddenly cannot edit my direct queries to my lakehouse the Edit query is grayed out? Anyone know whats going on? I just edited this on friday 9/12/2025

[v-pgoloju]

Hi @jimbobobwalker,

Just checking, have you had a chance to open a support ticket, as suggested. If so, we'd love to hear the current status or any updates from that.

If the issue was resolved through the support ticket, it would be great if you could share the solution here as well. It could really help other community members find answers more quickly.

Warm regards,
Prasanna Kumar

[OscarTh]

Looks like you're running into DirectQuery limitations - certain edits and transformations aren’t supported in that mode. Switching to Import or handling logic at the source (like with views) can help.

[v-pgoloju]

Hi @jimbobobwalker,

If the issue still persists, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Thanks & Regards,

Prasanna Kumar

[v-pgoloju]

Hi @jimbobobwalker,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @GeraldGEmerick and @Royel  for prompt and helpful responses.

Just following up to see if the Response provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[jimbobobwalker]

Collegue sent me this, not sure where he got it, but if true, seems like no. 2 is my issue:  

What's Changed in the September 2025 Update

1. Live Editing of Semantic Models Is Now Default

• Power BI now supports live editing of Direct Lake semantic models directly in Power BI Desktop and the Power BI Service.
• This means traditional DirectQuery workflows are being replaced or merged into Direct Lake and semantic model editing, which changes how queries are accessed and modified.

  2. Editing Restrictions for Legacy DirectQuery Models

  • Some older DirectQuery models may now be read-only unless converted to the new semantic format.
  • If your model wasn’t migrated, you might see restrictions like:
    • “We could not detect the data source information for this table.”
    • No access to Power Query or query folding options.

      3. Push Toward Cloud-Based Editing

      • Microsoft is shifting Power BI toward cloud-first workflows, including Power Query editing in the Power BI Service3.
      • This means some editing features are now workspace-dependent or require semantic model conversion to unlock full functionality.

[Royel]

Hi @jimbobobwalker  

You can check your Power BI version: Help -> About 

Latest error free version is: Version: 2.147.931.0

You can get this from Microsoft Store or from here  https://www.microsoft.com/en-us/download/details.aspx?id=58494 
If this not worked create a support ticket, visit https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket.

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!

[jimbobobwalker]

Looks like there was update yesterday 9/15, Version: 2.147.909.0, which we have. Trying to look thru the list of changes to identify what could casue the issue

[GeraldGEmerick]

@jimbobobwalker Check which version you are on. Microsoft just updated the Desktop to the September release so perhaps a bug was introduced? You can check this by going to File then Options and settings, Options and then Diagnostics.