直接通过Power BI发布的报告输入数据 [英] Input data directly through Power BI published report

问题描述

在发布的报告中是否有通过PBI直接输入数据的解决方法？我希望用户在图表中输入注释。如果用户可以在图表下方的PBI报告中直接执行此操作，那将是非常棒的。

我可以在官方PBI Ideas For Improvement页面上看到这些功能是开发人员的梦想被投票：

TextInput1 接受用户输入，保存 icon1 将 OnSelect 设置为设置（注释，TextInput1.Text）将文本从文本输入保存到变量 comment ;并且 Label1 显示评论值。

何时您在Power BI Web上编辑Power BI报告，从市场中添加 PowerApps Custom Visual ，然后选择您刚刚创建的应用程序，这将会发生：

请注意，这只是一个示例，并且在刷新时不会保留用户输入。如果要保存注释以将其显示给其他用户，则必须修改应用并将其连接到数据源，创建表以存储注释，使用用户输入更新其值等。

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

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13820190-power-bi-online-query-parameters?page=1&per_page=20

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发布的报告输入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！