It’s very easy to query SQL table-valued function to retrieve the result with Dataflows.
This is how we do this.

Let’s connect to a database. It will work via gateway as well.

Select your function.

Pass the parameter if required.

Now you can use this table to merge with other tables or map and load to Dataverse.

Super easy!
Continue Reading Olena Grischenko’s Article on their blog
https://msolenacrm.blog/2021/02/02/dataflows-for-power-apps-calling-a-table-valued-function-sql-function-with-power-query/
Blog Syndicated with Olena Grischenko’s Permission
More About This Author
Array
Power Automate10 August 2023Canvas App: Office365Users.Search UserV2 not working, but V1 does
Power Automate7 August 2023Co-pilot with Power Pages: new features to generate UI
YouTube7 August 2023Power Pages Copilot – YouTube
Power Automate19 July 2023Power Automate: Send approval email to external customer