Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Generate a data source from a SQL Stored Procedure with one parameter coming from drillthrough field

I have a Power BI report in DirectQuery Mode. In page 1, the user selects a field named PartNumberKey (which is an integer) and on drill-through, the report navigates to the next page which displays ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous,

 

#1, current power bi not support to invoke 'Stored procedure' in 'direct query' mode, please use import mode to instead.

 

#2, You can't extract value from data view level and use it as query parameter to generate new data model tables.

 

Data level: Left side can effect right side, right side can't effect left side.

Database -> query table(power query, query parameter, custom functions) -> data model(calculate table/column, RLS) -> data view(visual data, different level filter, slicers, measure).

 

Regards,

Xiaoxin Sheng

  • hunter's avatar
    hunter
    Regular Visitor
    7 years ago

    Hi Anonymous,

     

    Is there any support or movement on PowerBI's side to implement the ability to invoke a "Stored Procedure" in "Direct Query" mode in the near-future? This functionality would be well received by all if it could be done.