Forum Discussion

gijeet's avatar
gijeet
New Member
10 years ago

Call an SP

As a developer I spent years learning SQL and all it’s power – creating queries, CTEs, correlated subqueries, stored procedures with parameters, learning all the join conditions and filter conditions...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

aakgun

 

What do you mean "refresh of the remaining dataset", if you dataset is the execution result of an SP, when the passed parameters change, the result set changes accordingly.

aakgun's avatar
aakgun
Frequent Visitor
10 years ago

Hello Eric_Zhang,

 

In Power BI,when we invoke the new Parameter, It executes the SP with parameter but a new dataset table is listed in the Power BI.

I expect that I will have only one data table, (dataset) and SP Execution will  refresh its data.

  • aakgun's avatar
    aakgun
    Frequent Visitor
    10 years ago

     When I checked the steps, I missed applying the query change to the "Invoked Function" in the daset list. I have applied my changes to the Query 1 function, then it resulted every time a new dataset.

     

    As a result, using the Invoked Function dataset is OK for calling Stored Procedure and That is great!!.

     

    At this point , Is there any way of entering parameter data to the query, without using "Edit Queries" details.

     

    End Users need to enter their parameter information or select the requested data in the report screen and refresh the data withou using the "Edit Queries" details.

     

    Thanks for your kind comment ans support again.

    • Eric_Zhang's avatar
      Eric_Zhang
      Microsoft Employee
      10 years ago

      At this point , Is there any way of entering parameter data to the query, without using "Edit Queries" details.

       

      End Users need to enter their parameter information or select the requested data in the report screen and refresh the data withou using the "Edit Queries" details.

       

      Thanks for your kind comment ans support again.

      AFAIK, there's no way. The demo I showed is just to indicate that Power BI has that capability. However it is not a good practice in my opinion.

       

      Usually a report is developed in Power BI desktop and then published to Power BI Service. Refresh can be scheduled via a gateway. So instead of entering parameter, can all data be imported or in a DirectQuery(stored procedure is not supported in this mode based on my test) and filtered via a slicer?