URGENT!!!Unable to see the "EDIT SETTINGS" option in Power Query Editor

[MTAB1380]

HI All,

I am unable to see the "wheel" next to Query 1 as per the snapshot. It was present before but all of a s udden it appears to have vanished.

Previously I was able to click in the wheel and update the Query in order to fetch the data, but now I do not see it anymore.

Any help would be highly appreciated.

Thanks & Regards,

MTAB

[MTAB1380 · Accepted solution]

Hi team,

Thanks for all your help. I was able to resolve the issue. I shared the PBx with one of my peers and asked to share the entire Query which was visible in Query1, pasted into my broken Query1 within PowerBI and it worked. Thought of responding so that others may use if they encounter a similar situation.

Thanks team 🙂

[BA_Pete]

Hi @MTAB1380 ,

Based on the apparent urgency of this question, I would suggest that you go to the Home tab > Advanced Editor.

This will allow you to see and edit the entire query code, including the source query, in order to get done what you need to as quickly as possible.

We'll need to understand what your source step comprises of (e.g. query reference, native query, web query etc.) in order to get to a longer-term solution.

Pete

[MTAB1380]

Thanks @BA_Pete for your response.

I have an SQL query, prevoiusly I could see the wheel which on clicking would open up the SQL query and I could update as per the requirement.

Unfortunately, now I do not see the wheel and I am not sure what has caused this. I did to to install & uninstall PowerBI but of no use.

If you can guide me how to get that back it would be great.

[lukiz84]

Could you go to advanced editor and post the Line which says Query1 = ...? Would be helpful so we can help you 🙂

[MTAB1380]

This is how at appears :

let
Query1 = Value.NativeQuery(SapHana.Database(

After the bracket the connection details and queries start.

[lukiz84]

did you (maybe by accident) alter the code in advanced editor after you made the connection? then it could also happen.

[MTAB1380]

I wasn't aware of the Advanced Editor before, I always used the wheel next to the Query1 to make any changes.

[lukiz84]

Sorry, but "URGENT!!!"  ?

what is Query1 in Advanced Editor?

[MTAB1380]

Thanks @lukiz84 

My apologies for the URGENT tag, but I needed a quick resolution as am stuck all of a sudden.

Query 1 is an SQL query which is connected to SAP HANA.