Skip to main content

    Power BI

    Under Review

    Allow Excel slicers to act as a data source for Power Query

    Vote (170) Share
    Power BI Ideas Admin's profile image

    Power BI Ideas Admin on 05 Mar 2015 05:12:53

    It would be great if we could use the selected items in Excel slicers as a data source for Power Query. This would make it easy to use slicers as a way for users to select values to be used as parameters for other Power Query queries.

    Comments (9)
    Power BI Ideas Admin's profile image Profile Picture

    8b0685ff 3562-4200-9448-75d487328c9a on 05 Jul 2020 22:40:57

    RE: Allow Excel slicers to act as a data source for Power Query

    Another vote for this!

    Power BI Ideas Admin's profile image Profile Picture

    36d6c015 24fb-464c-b210-650b3e04c9a8 on 05 Jul 2020 22:34:24

    RE: Allow Excel slicers to act as a data source for Power Query

    This would fill an important hole that prevents us from adopting PBI. In order to fine-tune queries and not download the whole universe, we need to show users one or more slicers that help them refine and select what they want to load and analyze. User selections from these slicers then become an input to the queries that populate the data model.

    The current Parameters functionality is a great step, but it does not provide the desired functionality.

    Power BI Ideas Admin's profile image Profile Picture

    55d0d1ba 194a-46ef-80d1-62bd9d661910 on 05 Jul 2020 22:29:35

    RE: Allow Excel slicers to act as a data source for Power Query

    would make life easier

    Power BI Ideas Admin's profile image Profile Picture

    b9499e29 98ce-4883-aabc-8795c32a2174 on 05 Jul 2020 22:25:33

    RE: Allow Excel slicers to act as a data source for Power Query

    Are the Query Parameter options an option in this scenario?

    Power BI Ideas Admin's profile image Profile Picture

    1d9ca068 b058-4ecf-a55d-e42d6c01b0e4 on 05 Jul 2020 22:01:01

    RE: Allow Excel slicers to act as a data source for Power Query

    This would be extremely powerful and would greatly enhance PowerBI

    Power BI Ideas Admin's profile image Profile Picture

    46b48fbb d663-4761-8cdc-a5bc9e6c9649 on 05 Jul 2020 21:58:52

    RE: Allow Excel slicers to act as a data source for Power Query

    Having the ability to define slicers as a separate data source to pass back as parameters to the main query would be huge. Similar to SSRS where you can query define available parameter values.

    Ability to pass (easily) parameters into an excel power query would be huge, and get rid of the stupid native query warning each time I choose a new parameter!

    Power BI Ideas Admin's profile image Profile Picture

    c86d97cf e634-4d8f-b83a-54452878e981 on 05 Jul 2020 21:58:52

    RE: Allow Excel slicers to act as a data source for Power Query

    Definitely would be helpful!

    Power BI Ideas Admin's profile image Profile Picture

    6a61e791 22f2-4752-961d-5f9b7932e0f5 on 05 Jul 2020 21:58:45

    RE: Allow Excel slicers to act as a data source for Power Query

    So it might open up a lot of opportunities... It even would be more exiting if you would be able to use Power View slicers as well... Just imagine that you can pass parameters to an oData source (maybe something "odd" like SAP HANA) where you pass parameters of what you want to visualize in Power View. This would offload a lot of processing power and save a ton of data transfer time also enabling real-time scenarios...

    Power BI Ideas Admin's profile image Profile Picture

    4beb9472 9bea-4e6f-b144-80e0237eb304 on 05 Jul 2020 21:58:43

    RE: Allow Excel slicers to act as a data source for Power Query

    It would be more than 'GOOD' -- it would be FABULOUS !!!