Pass username as filter or parameter in query using DirectQuery to SQL?

Is it possible to pass userbname to stored procedure in mcode? If So how can i do that? 

Thanks

Is it possible to pass userbname to stored procedure in mcode? If So how can i do that? 

Thanks

No good in this case.

We want to filter by department defaults, so that if we are viewing sales by region or department the page loads with that specific region/department filtered first.

However, we don't want to prevent them from viewing other department/region data.

Basically we have SPO sites with various department landing pages and want a link back to PBI to take viewers directly to the PBI dashboard with the linking department filtered.