Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Source Query - Advanced Editor

I think I may be missing something simple. I uploaded a SQL Server data source with sql code. Example:

(

Select

Name,

Number

from Table

)

 

When I go into Power BI desktop later, I open the query editor, and go to advanced editor; the query is rewritten and has extra characters because it is using the "Source = Sql.Database" function.

 

How do I get the SQL query as I put it in? It is annoying to have to edit/format the query everytime I want to make a change.

 

Note: creating a view or stored procedure source is not an option in this case.

 

Thanks!

  • Hi Anonymous 

    Click on the Gear icon right to Source step in Right Query Settings pane

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

1 Reply

  • az38's avatar
    az38
    Community Champion

    Hi Anonymous 

    Click on the Gear icon right to Source step in Right Query Settings pane

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution