apurohit's avatar
apurohit
Frequent Visitor
7 years ago
Status:
Done

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

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? 

Data Modeling

4 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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

  • apurohit's avatar
    apurohit
    Frequent Visitor
    7 years ago

    Thanks for the quick response Anonymous. Do you know if there are plans to add this functionality? Is there a timeframe?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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

Completed Ideas