Skip to main content

Power BI

Needs Votes

direct query

Vote (133) Share
NickiT's profile image

NickiT on 02 Mar 2018 22:12:59

Ability to run stored procedure using direct query

Comments (24)
NickiT's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:07:56

RE: direct query

can't believe this doesn't exist still

NickiT's profile image Profile Picture

5fd3c902 bc2f-433c-8d7d-b88b1968d7e0 on 05 Jul 2020 23:57:40

RE: direct query

We have a multi-tenant scenario. I can't imagine how I'm supposed to manage 50+ versions of the same query for each one.

Come on, MSFT, Crystal Reports has allowed the use of SPs since the '90s, NP. Tableau/Qlik have no issues with this either...hmmmm.

NickiT's profile image Profile Picture

56b973c8 4ce0-4c45-a38e-feb757994f73 on 05 Jul 2020 23:53:43

RE: direct query

How does this not work out of the box. Same with the heir slicer it should just be there and work.

NickiT's profile image Profile Picture

7b348179 554f-4859-9448-c456986fd008 on 05 Jul 2020 23:53:10

RE: direct query

please allow... this

NickiT's profile image Profile Picture

1ae8be65 f88e-497e-8eca-16412c70b329 on 05 Jul 2020 23:51:21

RE: direct query

Our 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.

NickiT's profile image Profile Picture

085fa40f 091d-4d76-a12d-a705380f447d on 05 Jul 2020 23:50:55

RE: direct query

This is the basic requirement that should be available. Please add this feature at the earliest.

NickiT's profile image Profile Picture

ea5ae7f9 2efe-450c-8032-6e00196e6c1b on 05 Jul 2020 23:48:25

RE: direct query

This 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.

NickiT's profile image Profile Picture

a5cbc3b2 c1e0-49a3-9d5d-0e06411e480f on 05 Jul 2020 23:47:57

RE: direct query

I am guessing this feature has to be used as part of paginated reports

NickiT's profile image Profile Picture

3aff8bc4 fa3b-4a09-bb97-54ccc4a3ef02 on 05 Jul 2020 23:44:06

RE: direct query

can't believe this doesn't exist still

NickiT's profile image Profile Picture

4958a0b1 8123-4011-b6e9-649b436cafa7 on 05 Jul 2020 23:40:14

RE: direct query

How can this not be fixed yet?? Absolute show stopper.