cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dsewall Frequent Visitor
Frequent Visitor

Set fIlters prior to processing direct query

Hello - I'm familair with other BI tools and am looking for a similar functionality.  I have powerBI setup as a direct query.  I'm looking for a way for the users to select all of their filter criteria and then hit a button to launch the query, rather than the query kicking off with no filter criteria upon open.  Any suggestions?

1 REPLY 1
Community Support Team
Community Support Team

Re: Set fIlters prior to processing direct query

hi, @dsewall 

If you want to filter data sources, you need to use Parameters in Power BI.

https://blog.gbrueckl.at/2019/03/using-power-bi-desktop-direct-query-with-parameters/

https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/

https://docs.microsoft.com/en-us/power-bi/service-parameters

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

 

 

Best Regards,

Lin

 

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 507 members 4,229 guests
Please welcome our newest community members: