英文:
Trigger an Azure Function from Power BI
问题
我们正在使用Power BI嵌入式来显示来自Cosmos Db的数据。我们需要尝试以下功能：
- 显示一个带有聚合值的柱状图。
- 根据柱状图显示详细表格。
- 在表格中放置一个复选框（其中包含一个GUID）。选择多个GUID，然后单击将触发Azure函数，并将GUID作为输入发送到该函数。
我们能够完成＃1和＃2。是否可以使用Power BI嵌入式实现功能＃3？
英文:
We are using Power BI Embedded to display data which is coming from Cosmos Db. We have to try the following thing
- Display a Bar chart with an aggregated value
- Display the detailed table based on the Bar chart.
- Have a checkbox in the table (there is a GUID). Select multiple GUIDs and on a click this will trigger an Azure Function and send the GUID as an input to the function.
We are able to perform #1 and #2. Is it possible to achieve functionality #3 using Power BI Embedded.
答案1
得分: 2
我认为你可以通过与Power Automate集成来实现这个。请参考这篇文章：https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual?tabs=powerbi-desktop
- 创建一个具有可以触发Azure函数的HTTP连接器的Flow
- 将此Flow连接到Power BI中的Power Automate可视化
Flow应该能够在触发时接受上下文数据，例如这个GUID，以传递给Azure函数。你可以将GUID列（或计算所选GUID的度量）分配给Power Automate可视化。
英文:
I think you can do this by integrating with Power Automate. See this article: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual?tabs=powerbi-desktop
- Create a Flow with a HTTP connector that can trigger your Azure function
- Connect this Flow to the Power Automate visualization in Power BI
The Flow should be able to accept contextual data upon triggering, e.g. this GUID, to pass on to the Azure function. You assign the GUID column (or measure that calculates the selected GUID) to the Power Automate visual.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论