Forum Discussion

akosiRandy's avatar
akosiRandy
Frequent Visitor
3 years ago
Solved

How can I call a stored procedure in SQL Statement

In Ssrs, we can call a stored procedure with dynamic parameters,   EXEC usp_Client_Day @Start, @End, @MainCLient, @Client, 'CS,COS','NPG'   Quetion? How do you call a stored procedure with dyna...
Need Help
  • akosiRandy's avatar
    akosiRandy
    3 years ago

    Thanks. I guess by default i should just create the data range parameter within sql statement and create the other parameters in powerbi visual.

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

Hello akosiRandy ,

 

Power bi doesn't support stored procedures, you must create it as a view and then connect to it through Power BI.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

akosiRandy's avatar
akosiRandy
Frequent Visitor
3 years ago

Thanks. I guess by default i should just create the data range parameter within sql statement and create the other parameters in powerbi visual.