In Data Flows, i am trying to create some queries that need parameters. The parameters do not appear as parameters, but keep getting converted to tables.
My parameters and queroes work in PBIX in M, but not it the data flows.
What you suggested is what I did...
It does not work with APIs that work in PBIX.
DataFlows has a lot of issues as of yet since they have not ported over all the functionality from PBI Desktop Query Editor.
There are issues with API protocols in both PBIS and Data Flows. I have lots of queries that use APIs (Web.Content) that do not work in PBIS or Data Flows for various reasons.