Using SQL to override a parameter built into the data source

[peebes1]

My SQL Server database has an optional "fiscal year" parameter.  If no value is chosen at the database level, the default is to return data for only the current fiscal year.  I can't figure out how to use SQL to get Power BI to interact with the parameter and let me choose the fiscal year(s) I want.  If I use a SELECT statment with a WHERE clause for the fiscal year, it is too late, and the database is only sending through current fiscal year data.  In Tableau, I could use the OpenTable command (example below) to take control.  Is there a way I can get Power BI to do this as well?

OpenTable("Beneficiary"."Frequently Used Fields",
"Choose one or more Fiscal Years"= "[2023, 2024]"
) 

[Akash_Varuna]

The default behavior of Power BI’s SQL Server connector does not allow you to pass parameters directly into the database query. To address this, create a stored procedure in SQL Server that accepts fiscal years as input and dynamically retrieves data based on the parameter. Use Power BI to execute this stored procedure via DirectQuery and bind it to a parameter in Power BI for user selection.