You’re offline. This is a read only version of the page.
3
I have a project that has me stumped. I have to query a DB via on-prem (in a flow I guess?) gateway to use the result in Power Apps. I'd need to pass an invoice number to the query as a parameter to get the correct row using a fairly complex query with multiple joins. But direct native SQL queries are not supported for some reason I can't fathom.
Is there a way to do this in Power Query? I'd need to pass an ID to the query to get the correct data I would need, and the query would have to run whenever someone used the app, which could be anywhere from 0-50.
If not Power Query, is there any other way to do it?
Share
Report
All responses (
Answers (
