Forum Discussion
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 Re...
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):