Forum Discussion

pratikthakor's avatar
pratikthakor
Regular Visitor
7 years ago
Solved

change data set sql statement via api

Is it possible to change SQL statement of the dataset via API call?    My Scenario: I have data in multiple tables in SQL Server. I have created a SQL query with joins to fetch the required data. I...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi pratikthakor,

     

    >>"use query parameter with t-sql query as optional parameter in sql connector", is there any tutorial or document there to show steps on how to achieve it?

    Sure, below is a simple sample, you can test on it.

     

    let
	tsql=queryparameter,//query parameter is your t-sql string parameter
	Source= Sql.Database("ServerName", "databaseName", [Query=tsql])
in
    Source

     

     

    Reference link:

    Sql.Database

     

    Regards,

    Xiaoxin Sheng

pratikthakor's avatar
pratikthakor
Regular Visitor
7 years ago

How can I, "use query parameter with t-sql query as optional parameter in sql connector", is there any tutorial or document there to show steps on how to achieve it?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi pratikthakor,

 

>>"use query parameter with t-sql query as optional parameter in sql connector", is there any tutorial or document there to show steps on how to achieve it?

Sure, below is a simple sample, you can test on it.

 

let
	tsql=queryparameter,//query parameter is your t-sql string parameter
	Source= Sql.Database("ServerName", "databaseName", [Query=tsql])
in
    Source

 

 

Reference link:

Sql.Database

 

Regards,

Xiaoxin Sheng