Forum Discussion
Call an SP
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.
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?