Optional Paramater in Report Builder with Oracle Source

[Anonymous]

Hi Guys,

I am new to the Power BI report server and working on report builder to create parameters as my users want parameters instead of filters. Currently, the source which we are using is Oracle Database. I have created parameters and the dashboard is currently in deployment. But now the user wants to have optional parameters which meanThis the query I used for creating parameters directly in the Report Builder. they don't have to enter details for every parameter. Currently, I have created 3 parameters namely Subscriber Number, Start Date, and End Date. Could someone tell me how can I put optional parameters in the report?

Thanks in advance 🙂

[V-pazhen-msft · Accepted solution]

@Anonymous 

You can add parameter and display in the parameter panel. Please refer to the step-by-step tutorial.

Tutorial: Add a Parameter to Your Report (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.