Forum Discussion
dogburalHK82
Helper III
Helper IIIPower BI report builder parameter
Hi, I am trying to use parameter (like slicer) to filter the value in datasets. Quality_Defect is from Dax in power bi service; whereas PO is a fact table from power bi service Q...
managed to do referring to this https://www.mssqltips.com/sqlservertip/5865/sql-server-reporting-services-report-builder-with-dax-query-support/
GilbertQ
Super User
Super UserHi dogburalHK82
You have to pass the parameter into your query.
Here is an example on how to do this: Tutorial: Add a Parameter to Your Report (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Learn
dogburalHK82I added like below, but not working.
then, I just tried adding parameter under dataset
then, run but got below error
- dogburalHK82
managed to do referring to this https://www.mssqltips.com/sqlservertip/5865/sql-server-reporting-services-report-builder-with-dax-query-support/