This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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):
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 37 | |
| 32 | |
| 27 | |
| 24 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 50 | |
| 31 | |
| 25 | |
| 24 |