Allow user select specific rows from SQL Server with Direct Query and slicer

[Anonymous]

I have a chart which currently displays all the values from an Azure SQL server database which is connected to Power BI report with Direct Query. The data are refreshed in a specific interval. Apparently this database is populated with almost 300 values every day.

I could manage to retrieve only the latest 500 rows from the generated table through this advice.

The ideal scenario (and the demands of the client) is that through a input field (a slicer possibly?) the user of the report could retrieve a particular number of rows from the table that form the chart.

Is this possible?

Thanks in advance

[v-henryk-mstf]

Hi @Anonymous ,

Theoretically, there is no way to enter fields in powerbi to get results. But it is possible to count the number of rows of a table composed based on filter conditions by creating a measure formula. Azure SQL Database with DirectQuery

Can you further describe your requirements or provide relevant test data and screenshots of the desired results so that I can answer you as soon as possible?

Looking forward to your reply.

Best Regards,
Henry

[Anonymous]

Hi @v-henryk-mstf  and thank you for your answer,

Could you guide me through the process of creating a measure formula. My scenario include a slicer with checkboxes and the label "Choose latest number of values to generate graph". The checkboxes will be:

 500

 1000

 1500

 2000

where the numbers represent the latest values retrieved from the database.

Thanks again.