Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Bennett_12
New Member

Why is my Source step not showing the cog to select the source SQL query?

Hi all, 

 

I'm pretty new to power query/bi, so I hope I'm not missing something simple. I want to select my Source query from my applied steps. Normally I would select the cog next to the step and copy the query from there, however the cog is not showing up next to my Source step. Screenshot below, 

Bennett_12_0-1713365798942.png

. In the above field, I see remnants of a query, but it looks like it has been encoded to work with power query. 

How can I get my original sql query without going through the encoded part and changing every little detail?

 

Thank you!

1 ACCEPTED SOLUTION
watkinnc
Super User
Super User

The cog appears if you've used the GUI to make your code, and it usually disappears one you manually alter that code.

 

--Nate


I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

View solution in original post

1 REPLY 1
watkinnc
Super User
Super User

The cog appears if you've used the GUI to make your code, and it usually disappears one you manually alter that code.

 

--Nate


I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors