Forum Discussion

GLIDO's avatar
GLIDO
Helper I
8 years ago
Solved

Writing own sql queries

Hi there,   I am stuck with an issue.  I've imported 10 tables using PBI Desktop from oracle, and created the joins as well. Things were fine till here. Now I've to add a coulumn to the master tabl...
  • zoloturu's avatar
    zoloturu
    8 years ago

    Hi GLIDO,

     

    You are able to put Native Query to a connection as I show on the screenshot even when importing data.

    Please try.

     

    Regards,
    Ruslan
    -------------------------------------------------------------------
    Did I answer your question? Mark my post as a solution!

zoloturu's avatar
zoloturu
Memorable Member
8 years ago

Hi GLIDO,

 

When connecting to any relational database you can mention Native Query in Advanced options. See example below:

 

dq\

Regards,

Ruslan

GLIDO's avatar
GLIDO
Helper I
8 years ago

Hi Zolo,

 

The thing is I've to import the tables and cannot use the direct query option. 

Hence, I was trying the approach of first fetching the whole set of data and then filtering the data as per the needs, by using the sql queries. 

 

Thanks 

  • zoloturu's avatar
    zoloturu
    Memorable Member
    8 years ago

    Hi GLIDO,

     

    You are able to put Native Query to a connection as I show on the screenshot even when importing data.

    Please try.

     

    Regards,
    Ruslan
    -------------------------------------------------------------------
    Did I answer your question? Mark my post as a solution!