Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
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.
Add a parameter to the query:
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)
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):
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 66 | |
| 47 | |
| 43 | |
| 26 | |
| 19 |
| User | Count |
|---|---|
| 196 | |
| 127 | |
| 102 | |
| 67 | |
| 49 |