Forum Discussion

mdubose's avatar
mdubose
Helper I
3 years ago
Solved

Create custom query in Desktop

I have a need to replace Business Objects reports with Power BI.  In Business Objects, you're able to create derived tables which allows you to enter SQL expresssions.  Is there a way to do the same ...
Need Help
  • Padycosmos's avatar
    Padycosmos
    3 years ago

    Expand Advanced to get the SQL statement window

lbendlin's avatar
lbendlin
Super User
3 years ago

You can run multiple queries against the same data source (and they can be custom SQL). Each query will appear as a table in Power BI if you choose to load it.

  • mdubose's avatar
    mdubose
    Helper I
    3 years ago

    Hi lbendlin ,

     

    Where in Desktop, can I create this query?

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      You do that in the ETL portion called Power Query Editor.

      • mdubose's avatar
        mdubose
        Helper I
        3 years ago

        Hi lbendlin,

         

        Using this feature in Desktop is new to me, can you provide a screenshot of where in Power Query Editor, I could enter the query?  Thank you.