• Saravana

Passing Parameter to Stored Procedure from Power BI Report?



Do you want?


Do you want to learn How to Send Parameter from Power BI to Stored Procedure to get data? Is this Really Possible?


I have a Power BI report and source is SQL Stored Procedure and passing Date as a Parameter as below,


EXEC LatePaymentCustomers '2011-01-10'



Power BI Report Using the Stored Procedure





Business Function


The End user need to select the Date in the report to update data throughout the report.


Technical Function


The Date in the report to needs to be passed in Stored Procedure to get new data in the data set and display in the report.


Can we able to send date from Report to SQL Query to hit database and get new data?


It's Not Possible!


Power BI has a limitation to pass value from UI to Data Source Level


Reference Link 1

Reference Link 2

Reference Link 3



Alternative Solutions


Alright, what is the alternative now? Can't I able to do this anyway and consume it through Power BI Service?


Solution 1


Rewrite the store procedure to View without affect the Business Logic, Consume view as a table in Power BI and Filter the Report.


Yes, I know it's the Recommendation from all the blog you read!


Solution 2


Power BI Platform has another tool called Power BI Report Builder


Using Power BI Paginated Report Builder tool , You can build Paginated Reports and able to send parameter to Source Stored Procedure without writing Views and changing SP.



AforAnalytic helping Fortune 500 companies to build Power BI Reports and Providing solution to complex problem in the real world.


Thanks for Reading.. There is a Bonus for you


Bonus


There is a Limitation in using Power BI Report Builder that is Paginated Reports can be published to Power BI Premium Capacity License work space.



Conclusion


Every tool in a Business Intelligence Space has a limitation of some sort.


No Matter , there will be one Alternative Solution where you can find or company like AforAnalytic can able to help you out to reduce the time spent on Research & Analysis by providing Solution to problem in Very less time.


What do you think? Drop your comments below



35 views

A for Analytic

  • Facebook Social Icon
  • Twitter Social Icon
  • LinkedIn Social Icon
  • Instagram Social Icon

Chennai, Tamil Nadu, India

©2018 by A for Analytic