Query Editor is disabled

[grnelson]

Hi community,

I recently tried to add a DirectQuery from a company-owned data mart to my Power BI file. When I saved and closed out of Query Editor, I got an error message saying "The value is not a cube." Now the Edit Queries button is greyed out and I can't open Query Editor. Whenever I click the "Apply changes" button, I get the same error message. I can't figure out any way to get rid of the DirectQuery without opening Query Editor.

Any tips on how to get Query Editor working again?

Thanks in advance!

[grnelson · Accepted solution]

Thanks for the quick responses!

I'm not sure about accessing different versions of Power BI through my organization, but I'll be sure to ask my DBA about it if this comes up in the future.

In the meantime I was able to recover a previous version of my file by downloading from a published version and bring it up to date.

[v-gizhi-msft]

Hi,

According to your description, please confirm that you have updated Power BI Desktop to the latest version.

If you are trying to connect SAP HANA data source, please try to tick the the following options on Power BI Desktop:

Reference: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-sap-hana 

Best Regards,

Giotto Zhi

[edhans]

If it was a Live Connection to SSAS, you cannot edit the queries, but that is SSAS. You didn't specify the server type you were connecting to. That would help.

Your best bet though may be to just get a previous version of the PBIX and try again. That error could have been random, or could have been some sort of change on the server itself that was big enough that Power BI cannot compensate for. You'd need to discuss that with your DBA if that is the case to determine how to best proceed, and collaborate so they aren't making big changes to data you are using.