Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jvirgi
Helper III
Helper III

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 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?

1 ACCEPTED SOLUTION
marcosvin
Resolver II
Resolver II

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.

 

Analyzing datamarts (preview) - Power BI | Microsoft Learn

View solution in original post

2 REPLIES 2
jvirgi
Helper III
Helper III

Thank you @marcosvin .  I appreciate the confirmation

marcosvin
Resolver II
Resolver II

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.

 

Analyzing datamarts (preview) - Power BI | Microsoft Learn

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.