Forum Discussion

adelm's avatar
adelm
Frequent Visitor
6 years ago

Parameter in query

Hi

 

I am using Power BI to pull data from SQL Server, I would like to use parameters to change the company name in the query .

Below is an example for a simple query, my wish is to replace the XXX value with my list of paramters (Company number for instance).

Today I am creating seperate queries then merging all the data into one table, I would like to save hours of work by using a list of companies as parameters.

 

Thank you for your help

 

SELECT [Document Type]
      ,[No_]
      ,[Quote No_]
      ,[Sell-to Customer No_]
      ,[Shortcut Dimension 1 Code]
      ,[Shortcut Dimension 2 Code]
      ,[Salesperson Code]
      ,[Status]
      ,[Responsibility Center]
      ,[Quote Status]
      ,[Job No_]
      ,[Job Description]
      ,[Job Line Task No_]
      ,[Schedule Code]
      ,[Progress Code]
      ,[Job Task No_]
  FROM [NAV].[dbo].[XXX$Sales Header]

 

 

2 Replies