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

mdubose's avatar
mdubose
Icon for Helper I rankHelper I
3 years ago

Hi Padycosmos ,

In this video, it demonstrates added a SQL query when connecting to a SQL data source. I'm connecting via ODBC to a MySQL data source so I do not have the option to enter the query this way.