Creating Parameter for dataset

[Anonymous]

Hey, I am trying to create a Client parameter in my dataset, that when you change the client name on the parameter, all the tables update to only have the data for that client.  I created a server parameter and a client parameter. so P_Server & P_Client. Below is the query.

let
Source = Sql.Database(""&P_Server&"", "DW_Target", [Query="select *#(lf)from Table.Table#(lf)WHERE [Client]="&P_Client&""])

in
Source

However I keep getting the following error:

DataSource.Error: Microsoft SQL: Incorrect syntax near the keyword 'from'.
Details:
Message=Incorrect syntax near the keyword 'from'.
ErrorCode=-2146232060
Number=156
Class=15

[v-yanjiang-msft]

Hi @Anonymous ，

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, it's a SQL statement error, you use

SELECT column1, column2, ...
FROM table_name
WHERE condition 

statement in the below formula,

select *#(lf)from Table.Table#(lf)WHERE [Client]="&P_Client&"

Is *#(lf) your column name and Table.Table#(lf) your table name? I guess you just want to select all columns from the #(lf) table, you can modify the statement to 

select * from #(lf) WHERE Client ='&P_Client&'

More reference about the SELECT, FROM, WHERE statement: SQL WHERE Clause

SQL SELECT Statement

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.