Forum Discussion
Solved
Creating a Stored Procedure in a Datamart?
Is this possible? I created a datamart, and connect to it via the SQL endpoint in SSMS. Then in SSMS i tried to create a generic procedure with this code: USE [db_name];
GO
CREATE PRO...
Hello!
Currently there is no option to create procedures in Power BI datamart, only run SELECT commands.
To create stored procedures you will need to use other tools or functionality, such as Azure Synapse or Warehouse in Microsoft Fabric.
Hello!
Currently there is no option to create procedures in Power BI datamart, only run SELECT commands.
To create stored procedures you will need to use other tools or functionality, such as Azure Synapse or Warehouse in Microsoft Fabric.