pbiideas1
11 years agoNew Member
Status:
Under Review
Allow Excel slicers to act as a data source for Power Query
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.
10 Comments
- sduval3New MemberHaving 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!
- russell_chyz1New MemberDefinitely would be helpful!
- thomas34New MemberSo 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...
- james95New MemberIt would be more than 'GOOD' -- it would be FABULOUS !!!
- manel_sweetmoreNew MemberThis would be extremely powerful and would greatly enhance PowerBI
- dave49New MemberAre the Query Parameter options an option in this scenario?
- mikeresauNew Memberwould make life easier
- gwp
Advocate II
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. - wotlarxNew MemberAnother vote for this!
- fbcideas_migusrNew MemberStatus added:Under Review
Recent ideas
Not found value "Available gateway clusters"
Hi, Currently the machine (A) hosting power BI on-prime gateway standard. Machine (B) also want to host this server with machine (A). Gateway on (A) and (B) is using the same tenant as admin user. I...Thas_Michael1 hour agoHelper INew3Views0likes0CommentsFabric Deployment Pipeline Should Automatically Preserve or Upgrade Semantic Model Compatibility
Category: Microsoft Fabric — Deployment Pipelines | Semantic Models | Direct Lake The Problem When deploying a Direct Lake semantic model containing calculated columns or calculated tables throug...Murtaza_Ghafoor3 hours agoSuper UserNew2Views0likes0CommentsNative Page-Level Security (PLS) or Dynamic Page Visibility based on RLS Roles
Description: Currently, Power BI provides robust Row-Level Security (RLS) to restrict data rows, but it lacks a native mechanism to restrict or hide entire report pages based on user roles or USERPRI...Erick1813 hours agoNew MemberNew3Views0likes0CommentsAdd standard ADBC search paths for ADBC drivers in Power BI
Considering the benefits of using ADBC drivers for data intensive operations, it would be nice to allow ADBC drivers to be used that are not necessarily packaged with Power BI installations. To mitig...hsadlier-pdx15 hours agoNew MemberNew5Views0likes0CommentsPower BI Subscriptions: Suppress OOO Replies and Improve Sender & Management Options
With the recent changes to Power BI subscription email delivery, Out of Office and other automatic replies can be returned to the individual subscription owner. For automated subscriptions sent to l...svcrowell16 hours agoNew MemberNew15Views2likes0Comments