Hennie Borrenbergs on 26 Sep 2022 06:04:29
Are there any plans on being able to save created Datamart SQL queries from pulled data as tables/views? This would be an awesome feature to include within Power BI Datamart. This would give developers access to do the initial pull with power query and do basic transformations, and then give the developers the option to create complex SQL queries from the data pulled which would be accessible within the Datamart and dataset.
Michael Brodt on 09 Jun 2023 15:41:53
RE: Save Datamart SQL queries as tables/views to use in the dataset
This is a crucial component to making DataMarts a viable solution. We would want to be able to add in data from a data source, transform the base tables in Power Query, create our views and measures in the DataMart, and have those tables, views and measures all available in the dataset and selectable for additional datasets.