Parameterized Stored procedure in POWERBI or SSRS report should fetch the data from table every time when we select parameters

Question

I have below report requirement.

1. I have a table in sql server database. I create parameterized procedure in that
2. I should create a report either powerbi or ssrs sothat when I select filters or parameters it should fetch the data from db table every time i.e the stored procedure in report should hit the table every time.
3. Here data in table is freequently changing. when I run the report it should give latest data from table.

I would like to do this requirement in PowerBI, if not possible then in ssrs.

Please give a solution.

Answer 1

Hi,

SSRS / PBIRS are both ad-hoc reports, each time the user open the report, it will query the up to date data and render the report with newest data.

Just follow : Create a Basic Table Report this will meet you requirement.

regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Users always get connection timeout problem when using multi subnet AG via listener. Especially after failover to another subnet ----Hot issues October

Answer 2

Hi @siva rama krishna reddy tangirala ,

Do you mean that when you select the parameters it should get the newest data from db table?

In Visual Studio 2017, click on the Preview tab of the report.

On the icon tool bar there is a refresh icon that will pull the latest data from your database when you click it.

If you run the report from report server, the data will refresh automatically which means it will get the newest data from db every time you run the report.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October