Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0
apurohit

Passing Parameters to a Stored Procedure or table function in DirectQuery mode

Submitted by on ‎03-11-2019 04:05 PM

Hi,

 

I've found that it is possible to call a stored procedure (using OPENROWSET) pass in parameters when using DirectQuery mode.

 

However, this is only possible in PowerBI Desktop. Once the pbix is uploaded to an embedded workspace, there is no way to modify parameter values. (This works fine in import mode)

 

Is there any way to do this? 

Status: Delivered
See more ideas labeled with:
4 Comments (4 New)
Comments
v-yuezhe-msft
Employee
Employee
‎03-11-2019 11:44 PM

@apurohit ,

I am afraid that it is not possible to modify parameter in Power BI Service  for directquery dataset, you would need to modify the parameter in Power BI Desktop and then re-publish the PBIX file.

If you concern about this issue, please submit a feature request in Power BI ideas forum.

Regards,
Lydia

v-yuezhe-msft
Employee
Employee
‎03-11-2019 11:45 PM
Status changed to: Delivered
 
apurohit
Frequent Visitor
‎03-12-2019 08:23 AM

Thanks for the quick response @v-yuezhe-msft. Do you know if there are plans to add this functionality? Is there a timeframe?

v-yuezhe-msft
Employee
Employee
‎03-12-2019 08:27 PM

@apurohit ,

As far as I know, currently , there are no plans to add this functionality. You can create a feature request in Power BI ideas forum, once many people vote this idea, Power BI team would consider to add this feature.

Regards,
Lydia

Idea Statuses