Get Samples Page

[Anonymous]

Hello All,

I have a question if it possible to implement Get Samples page

it suppose have many filters (start date, end date, and operator)

and main button for export data from database not a table loaded in power bi (it take the values from filters and make a sql query to batabase and exported data in csv file)

Thanks in advance.

[MFelix]

Hi @Anonymous ,

For this you need to combine Power Automate with Power BI, picking up the values from the slicers you could add them as variables on the SQL using a power automate and link that to a button within Power BI.

See examples of the SQL for CSV you need to change the first step to pick the information from the Power BI instead of the action it shows.

https://blog.crossjoin.co.uk/2018/09/26/using-power-query-and-microsoft-flow-to-automate-the-creation-of-csv-files/

https://powerusers.microsoft.com/t5/Building-Flows/Saving-SQL-query-results-to-csv-on-sharepoint/td-p/817424