Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.