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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors