Forum Discussion
Power BI Desktop Issue
Hi Guo
I haven't encountered a general issue with the "Edit Query" functionality in Power BI Desktop. Since the problem only occurs with a specific file, it likely isn't a widespread bug but rather a limitation or a configuration issue.
A few things you might want to check:
- DirectQuery Connection: If your file is using DirectQuery mode, some transformations in Power Query may be restricted.
- Live Connection to a Published Model: If the dataset is hosted on a Power BI service or Analysis Services, you won’t be able to modify queries within Power BI Desktop.
- Corrupt PBIX File: Try opening an older version of the file or checking whether the issue persists when starting a new report.
- External Dependencies: If your queries reference external files, databases, or APIs, there might be connection issues preventing Power Query from loading.
If none of these seem to be the issue and everything appears correctly configured, I’d recommend opening a support ticket with Microsoft for further investigation.
https://support.fabric.microsoft.com/support/
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Guo,
Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.
This not only closes the loop on your query but also helps others in the community solve similar issues faster.
Thank you for your time and feedback!
Best,
Prasanna Kumar
Hi Guo,
Great to hear that it's working as expected on your end! Could you please accept as solution? It would be really helpful for others in the community who might be facing similar issues and can address them quickly. Also, I would suggest accepting your approach as the solution so that it can benefit others as well.
Thank you & regards,
Prasanna Kumar