Excel 365 - update SQL code - how to?

H

hollyanneu2

New Member
Joined
Feb 12, 2013
Messages
27
Office Version
  1. 365
Platform
  1. Windows
Hi All:

How do I update the code in the data source? This is greyed out. Love the new and simpler updates to the SQL functions (as if incorporating some features from Power BI however.....
SQL issue.JPG
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
Hi,

You need to go back to Power Query Editor, find your query and press the Cog icon right next to the "Source" step - this will open the same window but this time it will allow you to edit your SQL statement.

1580312717374.png
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Countif solution in DAX
Replies
8
Views
188
RoryA
RoryA
K
  • Question Question
Power query - stopping refresh if no data available
Replies
2
Views
204
Kariba
K
R
  • Question Question
Get data from Power Platform - Transform not available?
Replies
6
Views
175
RoryA
RoryA
F
  • Question Question
Power query not picking up extra data in Excel table.
2
Replies
10
Views
439
RoryA
RoryA
J
  • Question Question
Importing multiple JSON files into useable Excel format.
Replies
2
Views
257
jimbomcmucka
J

Forum statistics

Threads
1,223,810
Messages
6,174,763
Members
452,582
Latest member
ruby9c

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top