Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Get Samples Page

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 t...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

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