fbcideas_migusr
6 years agoNew Member
Status:
Needs Votes
Allow Dataflow Import with AllowNativeQueries=TRUE or Dataflow JSON edit
When using the new import feature you can only import a dataflow model that has the AllowNativeQueries attribute as FALSE. There should be the capability to either: import dataflow model JSONS where this attribute is TRUE modify dataflow JSON and republish without having to go through the standard edit screen which can take FOREVER for it to load a preview of data and validate the model. My big beef with dataflows is that often times I'm making a small modification to the SQL associated with one entity (i.e. adjustment to the WHERE clause that has no impact on columns returned). With big entities it can take forever to make these updates as 7 out of 8 times the query validation will timeout after 10 min. I know this is less business ETL oriented but I'd love to be able to modify the JSON, i.e. SQL query and columns, etc. without going through the slow validation process. I was hoping to be able to export JSON models, make minor adjustments and then import as a new dataflow but AllowNativeQueries has to be set to false on import meaning that in order to get the dataflow to run I would always have to do the UI edit/validation process which again takes forever. Thanks!
2 Comments
- edgar_waltherNew MemberYou can change it in the json after downloading. Then import the json for the dataflow. Then with an api call you can update the AllowNativeQueries=TRUE. More info: https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/update-dataflow But that's quite a hassle, why not just make it work?
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Data Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v18 hours agoCommunity ChampionNew618Views11likes2CommentsSemantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v1 day agoCommunity ChampionNew21Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401971 day agoFrequent VisitorNew6Views0likes0Comments