问题描述
是否有任何解决方法可以在已发布的报告中直接通过 PBI 输入数据?我希望用户在图表中输入评论.如果用户可以直接在图表下方的 PBI 报告中执行此操作,那就太棒了.
我可以在官方的 PBI Ideas For Improvement 页面上看到,这些功能是开发者的梦想被投票:
TextInput1
接受用户输入,保存 icon1
将 OnSelect
设置为 Set(comment, TextInput1.Text)
将文本输入中的文本保存到变量 comment
中;Label1
显示 comment
值.
当您在 Power BI Web 上编辑 Power BI 报表时,从市场中添加 PowerApps 自定义视觉对象
,然后选择您刚刚创建的应用,将会发生以下情况:
请注意,这只是一个示例,它不会在刷新时保留用户输入.如果您想保存评论以将其显示给其他用户,您必须修改应用并将其连接到数据源、创建表来存储评论、使用用户输入更新其值等.
Is there any workaround to input data directly through PBI in published report? I would like the users to input comments to the graphs. It would be fantastic if the user could do that directly in PBI report, below the chart.
I can see on official PBI Ideas For Improvement page that these features are developers' dreams to be voted:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9414921-input-fields
Maybe there is some hidden workaround to that which slips out beyond the attention of Microsoft team? Maybe there is some visual, or script in R which allows sending data anywhere where it can be stored - SQL Server, Sharepoint?
Here is very inspiring hint example of IO made in R - passing clicks coordinates done in PBI to SQL and then back to Power BI:https://medium.com/@dr_eldersveld/r-visuals-in-power-bi-beyond-plots-74c618f2e6f3
Yes, it's entirely possible.
You can create a PowerApps (which basically allows you to connect to any (or most) data sources) and then embed the app in Power BI with PowerApps custom visual. It may take some effort but the use case is unlimited.
The following shows a simple example on how to save and show user input in PowerApps:
The TextInput1
accepts user input, the save icon1
have OnSelect
set to Set(comment, TextInput1.Text)
to save the text from the text input to the variable comment
; and the Label1
shows the comment
value.
When you edit the Power BI report on Power BI Web, add the PowerApps Custom Visual
from the marketplace, and choose the app you just created, this is what will happen:
Note that this is just an example and it won't persist user input upon refresh. If you want to save the comment to show it to other users, you'll have to modify the app and connect it to a data source, create a table to store the comment, update its value with user input, etc..
这篇关于通过 Power BI 发布报表直接输入数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!