Forum Discussion

mdubose's avatar
mdubose
Icon for Helper I rankHelper 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
Icon for Super User rankSuper User
3 years ago

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

mdubose's avatar
mdubose
Icon for Helper I rankHelper 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.

  • Padycosmos's avatar
    Padycosmos
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Expand Advanced to get the SQL statement window