Power BI Error Message

[twildone]

Hi,

I am getting an error message when I try and run the code in Power BI but it works when I run it in Microsoft SQL Server. What I am trying to do is create a proper case function to be used to correct a string of characters selected from another table. Any suggestions what I am not seeing....thanks

.[PCase]', 'fn') IS NOT NULL
  DROP function [dbo].[PCase];
go

CREATE FUNCTION [dbo].[PCase]  
(@Input as varchar(8000))  
RETURNS varchar(8000)  
AS  
BEGIN  
DECLARE @Reset bit,  
@Proper varchar(8000),  
@Counter int, 
@Input varchar(8000),  
@FirstChar char(1)  
SELECT @Reset = 1, @Counter = 1, @Proper = ''  
WHILE (@Counter <= LEN(@Input))  
BEGIN  
SELECT @FirstChar = SUBSTRING(@Input, @Counter, 1),  
@Proper = @Proper + CASE WHEN @Reset = 1 
                            THEN UPPER(@FirstChar) 
                            ELSE LOWER(@FirstChar) 
                            END,  
@Reset = CASE WHEN @FirstChar LIKE '[a-zA-Z]' 
                THEN 0 
                ELSE 1 
                END,  
@Counter = @Counter + 1  
END  
SELECT @Proper = REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(@Proper)),' ',' '+ CHAR(7)) , CHAR(7)+' ',''), CHAR(7),'')  
WHERE CHARINDEX(' ', @Proper) > 0  
RETURN @Proper;  
END; 
go
]