Dataflow download/upload support
Discussion for the possibility of enhancement, for downloading/uploading dataflows from/to Power BI Service. Benefits Tabular Editor (TE) and Power Query Online (Dataflows in Power BI Service) are a natural and powerful fit. TE enables from scratch creation of tabular models and enterprise grade functionality for development and source control. Dataflows provide cloud based ETL. The combination allows simple M language to be used for all data sources in TE, example: let Source = PowerBI.Dataflows(), Workspace = Source{[workspaceId = DATAFLOW_WORKSPACE]}[Data], Dataflow = Workspace{[dataflowId = DATAFLOW_ID]}[Data], Entity = Dataflow{[entity = "Date"]}[Data] in Entity Features - Download a subset (regex on name perhaps) of the dataflows from a nominated workspace to .json files in a local project folder. - Upload dataflows from .json files to Power BI service. - The download could be triggered during Save All (Ctrl+S) when connected to a development workspace. - An option or button to upload dataflows during model deployment to a workspace. Current Solutions Currently the above can be achieved with additional manual steps (like remembering to download .json files before a git commit), but it's easy to forget the step. Download/upload is available in Power BI Service web interface, the REST API and PowerShell MicrosoftPowerBIMgmt module. PowerShell examples in the git repo Not sure if C# or other modules/APIs available.
0 Comments
Sign in to comment
No comments yet. Be the first to share your thoughts!
