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,
We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.
If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution — it helps others who might face a similar issue.
Warm regards,
Prasanna Kumar