Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
adelm
Frequent Visitor

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 2

Thank you for your answer, this is not what I am looing for, with your solution I need to switch between each parameter manually.

What I am looking for is more like a loop into company names listed in param list to refresh the data

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.