Forum Discussion
Pass username as filter or parameter in query using DirectQuery to SQL?
Is there anyway to pass UserName() or userPrincipalName() as a query parameter when doing direct query? For example, if I want to direct query on today's sales I can handle queries like getting t...
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.
Is there anywhere I can vote for this enhancement? I have 100 million rows in a table. I can't refresh 25GB every day just so 10 people can access 100,000 rows