admin 管理员组

文章数量: 1086019

I’m working on a task that involves integrating a Power BI report, an Azure Function App, and a SQL database to filter documents based on user permissions.

Overview of the Task:

  1. Users will trigger the Function App from Power BI by clicking a link in the report.
  2. This link should include an SHA1 key for authentication and filtering purposes in the SQL database.
  3. When a user clicks the link, I also need to retrieve their email address for validation and access control.

Visual:

What should happen:

  1. The user clicks a link to trigger the Function App.

  2. The function processes:

    2.1. The SHA1 key from the URL.

    2.2. The email address of the user who clicked the link.

  3. It then queries the SQL database, filtering records based on:

    3.1. The provided SHA1 key.

    3.2. The user’s access permissions.

Response Handling:

  1. If the user has access, the function returns one row
  2. If the user lacks permissions, the function returns the message: "Not Authorized"

Questions:

  1. Generating Unique URLs:

How can I generate multiple function app URLs containing SHA1 keys?

Example format: =

  1. Retrieving User Email on Click:

How can I capture the user’s email address when they click the link?

Additional Notes:

I came across something called HTTP Trigger in Azure Functions, but I’m not familiar with function apps. Any guidance or advice on how to implement this would be greatly appreciated.

本文标签： pythonFunction app and powerbitrigger function from powerbiStack Overflow

版权声明：本文标题：python - Function app and powerbi - trigger function from powerbi - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://roclinux.cn/p/1744099735a2533441.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。