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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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