Christopher Wagner on 2022-06-02 12:54:28
We need the ability to create DDL and DML support in Power BI Datamarts so we can create stored procedures and views within the datamarts. This opens up endless possibilities for building and managing data within an analytics environment.
Sharing data with Apps can be easily done with stored procedures.
Consistent naming conventions, common business logic can be maintained in views.
Really, the list goes on and on.
Please enable this functionality.
Ideal it would be GUI driven for business users, but at a minimum programmatic creation works.
Administrator on 1/31/2023 10:32:06 PM
Thank you all for your votes so far! Would love to understand what's most important to you as far as DML and DDL - and what scenarios you're trying to deliver. Feel free to respond here and let our team know! :)
- Comments (8)
- Merged Idea (1)
Mimoune Djouallah on 2022-05-26 10:07:30
add Table function to Datamart
Currently Datamart don't support the creation of Table function, we have a use case where we want to push some GIS calculation at runtime to datamart using parameter, currently it is not possibleI added a blog for this use casehttps://datamonkeysite.com/2022/03/08/first-look-at-d...