Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 PROCEDURE model.uspGetEmployeesTest2
@LastName nvarchar(50),
@FirstName nvarchar(50)
AS
SET NOCOUNT ON;
SELECT *
FROM model.tablename
WHERE attribute = @FirstName AND attribute2 = @LastName
;
GO
But i just get a permission denied error. Is there any way to grant myself permission to create this in the datamart?
Solved! Go to Solution.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.