khaled Chowdhury on 14 Nov 2019 13:23:58
Ability to copy paste queries from PBI Desktop/Excel to DataFlow in PowerBI Service to create new DataFlows.
The UI in PBI is more friendly, we often design the queries in Excel and PowerBi Desktop, to copy them into service, especially for the nested queries, it's a long and arduous process of copying each one into the service from advanced Editor and matching names.
We are making a lot of data behind datasets available to the users. It'll be very convenient for major users of DataFlows
Administrator on 07 Dec 2020 22:38:16
In Excel and Power BI Desktop you can already do this. Improvements to the Service are coming: Generate a new dataflow from Power Query queries in an existing Excel file - Power Platform Release Plan | Microsoft Docs
- Comments (2)
RE: DataFlow Copy/Paste Queries from PBI Desktop/Excel
Check out this video by Guy in a Cube: https://youtu.be/YWp4FKzIBxM where he demonstrates the ability to copy the query between Power Query and Power Query Online.
RE: DataFlow Copy/Paste Queries from PBI Desktop/Excel
Hoping that this becomes a reality one day. If we can duplicate a dataflow by exporting it to JSON, then importing it in the "Create Dataflow" option, maybe a similar mechanism can exist for moving queries from Desktop to Dataflow? (I would be thrilled if I could multi-select a few queries from Power Query in Desktop and export them to a JSON file.)