Forum Discussion
Edit Existing SQL
You can modify it by clicking on the wheel on the source Step in the query settings
or modify the Query parameter in the Advanced editor
/erik
Power Query has a "split query" option to break a query into 2 pieces. hence you can break your query into a "source" and then transformation this way. Then you can point to the new source and create a new query from that.
In my experience, I tend to write my queries in SSMS first, then paste them into the Query window when creating a new query. I find it easier and more flexible. The only exception is if you want to use Query Folding with a table from within Power BI, then it is better to use a native query.
Hi, MattAllington I don't know u got me wrong or i did...!!
I too follow the same SSMS way. But what um asking is, once um done with
1. writing SQL in SSMS and then Copying that SQL statement in
2. Get Data> SQL Server > SQL Statement Window,
3. Importing the data / Loading the data in the report (PBI Desktop)
can i modify the query which i wrote at the get data in 2nd step...??:smileyhappy:
Hi,
You can do that via the Applied Steps in your Query editor or using the advanced editor via the View tab and then modify your M/Power Query script
Or even better create a parameter and use that parameter in your query
/Erik
hi donsvensen um not aware of M/Power Query Script and i got a few modfications in my query through updating the previous SQL statement in SSMS. i want to use the updated SQL instead of the SQL i provided to the report before.
should i create another data connection and add another query to the report with the updated SQL is this the only choice do i have..??
or
is there anyway to update the old SQL of the Existing Query..?
You can modify it by clicking on the wheel on the source Step in the query settings
or modify the Query parameter in the Advanced editor
/erik