Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Hi @Anonymous ,
A simple hack we use is to put our parameters into a SharePoint excel/csv. Then load and filter as necessary.
Hi @GilbertQ
What does mean "create a Data Flows if it is not updatable"?
So How can we use these Data Flows, please ?
Thank you for your reply
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.