Forum Discussion

SJi's avatar
SJi
Frequent Visitor
8 years ago

How to use stored procedure to get data?

  Hello,   we have stored procedures made for our mobile and paginated reports and we would like to use them with PowerBI. The procedures often have temp tables and parameters. I've enabled opeque...
Connection
SJi's avatar
SJi
Frequent Visitor
8 years ago

I've found there're basicaly 3 ways how to utilise stored procedure in Power BI:

  1. Using and executing variable
  2. Openquery
  3. Table-Valued Function

It seems, the most straightforward way is to execute variable which stores stored procedure call, however I'm having some troubles in doing so.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi SJi,

     

    Thanks for your sharing.

     

    Regards,

    Yuliana Gu