Forum Discussion

inspirz's avatar
inspirz
New Member
8 years ago
Solved

Advanced Editor from SQL Database

Hi,   I created a Direct Query to a SQl database to bring in production rate information. When I click "Get Data" and then select the SQL table and right click and then I choose "Edit" and then sel...
  • parry2k's avatar
    parry2k
    8 years ago

    this is where you will put your query:

     

MFelix's avatar
MFelix
Super User
8 years ago

Hi inspirz,

 

can test this out but believe tha you can select the direct query and then the advance options you can write your SQL statement like you would:

 

Select 

    StreamID,

    Description

From

    Table

Where

    StreamID = 1 or StreamID = 2

 

Regards,

Mfelix

 

Regards,

MFelix

  • inspirz's avatar
    inspirz
    New Member
    8 years ago

    Thanks a lot. I'm new to all this but I thought in Power BI Advanced Editor the power Query language had to be structured with "let" and "in" and not "select" "from" "where" but I'll try it out.

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      this is where you will put your query:

       

      • inspirz's avatar
        inspirz
        New Member
        8 years ago

        Thanks. That worked. I feel like an idiot now.

  • inspirz's avatar
    inspirz
    New Member
    8 years ago

    ok that didn't work....

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      what didn't work? What error you are getting? Make sure to enter your "sql server name" in server.