Forum Discussion

Charline_74's avatar
Charline_74
Icon for Resolver I rankResolver I
7 months ago
Solved

Translytical, UDF and Warehouse + Service Principal

Hello, I have set up Translytical with a UDF that performs INSERT operations in a warehouse. The thing is, my tool is designed to allow a large number of people to use the report and insert informat...
data engineering
User Data Functions
  • spaceman127's avatar
    spaceman127
    7 months ago

    Hi Charline_74,

     

    I use Translytical TaskFlows and had the same problem, which I solved as follows.

    1. I created groups in Entra and added the users who are to use the report.
    2. Then, under Managed Permissions in Functions, I added the group and gave it Read and Execute permissions. This allows the user to execute the functions in the reports.

     

    See the screenshot showing the permissions in the functions.

     

     

     

    If you have any further questions, please feel free to contact us and i hope this helps

     

    Best regards

     

    Feel free to leave kudos or accept it as a solution. This will also help other community members.

     

     

spaceman127's avatar
spaceman127
Icon for Super User rankSuper User
7 months ago

Hi Charline_74,

 

I use Translytical TaskFlows and had the same problem, which I solved as follows.

1. I created groups in Entra and added the users who are to use the report.
2. Then, under Managed Permissions in Functions, I added the group and gave it Read and Execute permissions. This allows the user to execute the functions in the reports.

 

See the screenshot showing the permissions in the functions.

 

 

 

If you have any further questions, please feel free to contact us and i hope this helps

 

Best regards

 

Feel free to leave kudos or accept it as a solution. This will also help other community members.