nicki_tinson
8 years agoNew Member
Status:
Needs Votes
Ability to run stored procedure using DirectQuery
Ability to run stored procedure using direct query
37 Comments
- akshay_abnaveNew MemberMust have feature. Tableau support this. We have shifted to Tableau due to this limitations.
- hina_shahNew MemberThis is important - also needed to port from SSRS
- gabriel_ofranc1New Memberit's more easier call only a SP rather than develop a whole SQL code in PBI
- pbiideas1New MemberWould like to be able to feed the procedure a selected value.
- JEFF_MOORENew MemberHow can this not be fixed yet?? Absolute show stopper.
- naveen_pamidiNew Membercan't believe this doesn't exist still
- atandraNew MemberI am guessing this feature has to be used as part of paginated reports
- jefmesNew MemberThis is a crucial feature needed for teams using Power BI Report Server. We have existing stored procs that have been vetted over time that we use in SSRS regularly, and we need to have these available to our Power BI reports.
- subhrajit_ghoshNew MemberThis is the basic requirement that should be available. Please add this feature at the earliest.
- kent_smithNew MemberOur users expect the data to be real time when it's queried - direct query allows that, but isn't allowed to use stored procedures that return data. Table value functions are an alternative, but for one of our basic scenarios, the data has to be returned from a stored procedure. This really hinders us from using Power BI. Please include this feature.
Recent ideas
Paste values in slicers for hierarchy data
Hierarchical slicers are widely used in enterprise reports (for example Product RCN > SKU Key, Region > Country > City, or GPP > Division > RCN > SKU). Users often need to bulk-filter by pasting valu...eddieisking200050 minutes agoFrequent VisitorNew4Views0likes0CommentsPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes3 hours agoNew MemberNeed Clarification202Views3likes2CommentsMake Copilot Approval status for semantic model available through API
In recent versions fabric allowed to mark a semantic model as approved for copilot to reduce AI adoption friction. However there is no specific way for external governance application to analyse whi...FrançoisD3 hours agoFrequent VisitorNew11Views2likes0CommentsClone a workspace, including its data, to a new workspace
Description: Today there's no way to fully clone a Fabric workspace: git sync and Deployment Pipelines move item definitions only, not the underlying data; Warehouse's zero-copy CREATE TABLE ... AS ...gclements4 hours agoHelper IINew12Views1like0CommentsAllow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara10 hours agoNew MemberNew8Views0likes0Comments