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