Forum Discussion

srineo's avatar
srineo
Regular Visitor
8 years ago
Solved

M query to SQL

Hi all,   I use Import option and oracle SQL to pull data from source. Then i add few steps in powerbi to arrive final table data for visuals. I've also manually edited M query to include parameter...
Need Help
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi srineo,

     

    SQL statement is used to achieve data from database and load these data into power bi. Power Query is a built-in language which is often used to shape and transform data. So SQL statement can't replace M query. Inversely, the SQL statement is wrapped by M query function such as Sql.Database(server as text, database as text, optional options as nullable record). 

     

    In addtion, if you are using query parameter in your sql statement, it means the table you achieved from database will be changed, every steps below should also be modified according to your requirement.

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi srineo,

 

SQL statement is used to achieve data from database and load these data into power bi. Power Query is a built-in language which is often used to shape and transform data. So SQL statement can't replace M query. Inversely, the SQL statement is wrapped by M query function such as Sql.Database(server as text, database as text, optional options as nullable record). 

 

In addtion, if you are using query parameter in your sql statement, it means the table you achieved from database will be changed, every steps below should also be modified according to your requirement.

 

Regards,

Jimmy Tao