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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
KathleenTBrooks
New Member

Teradata SQL Assistant query w/parameters create report w/Power BI Report Builder

I created a query to connect to teradata with a parameter:

 

SELECT * FROM USS_RXDW_ACCESS.CLNT_DIM_LOB
WHERE LOB_CD = '?LOBCODE'
ORDER BY LOB_CD

 

I then created a new report using Power BI Report Builder with this query.  The parameter is created when I run the report but it is not filtering the data base on my input to this parameter.  How do I fix this?

2 REPLIES 2
KathleenTBrooks
New Member

The link you sent is for SQL Server Report Builder.  I am using Power BI Report Builder with a connection to Teradata.  I've included more details to be sure the issue I am experiencing is being understood properly:  

 

Steps I used to create a new Power BI Report Builder report from a Teradata Query I created using Teradata SQL Assistant.

KathleenTBrooks_0-1663026552753.png

 

 

Add a parameter to the query:

KathleenTBrooks_1-1663026552773.png

 

KathleenTBrooks_2-1663026552774.png

 

KathleenTBrooks_3-1663026552784.png

 

 

Create a new report in Power BI Report Builder with the query from above.

Create a new report in Power BI Report Builder

Create a datasource to connect to Teradata (EDWP)

KathleenTBrooks_4-1663026552786.png

 

KathleenTBrooks_5-1663026552786.png

 

KathleenTBrooks_6-1663026552790.png

 

 

KathleenTBrooks_7-1663026552793.png

 

 

A parameter is not created for LOB_CD and no data is produced once I put in the parameter in the dataset query (see screen shot below):

KathleenTBrooks_8-1663026552797.png

 

 

 

 

amitchandak
Super User
Super User

@KathleenTBrooks , refer if this can help

https://docs.microsoft.com/en-us/sql/reporting-services/tutorial-add-a-parameter-to-your-report-repo...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors