User input saved within Power BI Table

[Saarek]

Hello everyone, me again!

I have a dataset in Excel that is currently sent around quite a few offices. This dataset includes a user selector where the users can choose either a yes or a no and then a user editable comments column.

Once they all fill in the sheet with their answers and comments I run the next stage.

This is cumbersome and I figure there must be a simpler way with Power BI!

The closest I can seem to find for this functionality is something called Flow which I believe is a Powerapp (don't really know what a Powerapp is, assume some expensive add-on for functionality that should already be in the product).

Is there a way to build a simple report with just a Pivot Table with some filters and a user selectable Yes/No column that will save that response to either the original table or a linked table that I can then export into Excel? Preferably at no addidional cost to the server based "Pro" licence that my team has already had to buy.

My head say there must be a way to do something so simple, but perhaps I am wrong as a bit of google did not give me any easy to follow guides online.

[SteveCampbell · Accepted solution]

There is no native functionality for this. By design, Power BI is not meant to collect data or edit data sources. It is used only for reporting / ETL as part of the data platform.

Power Apps is a seperate product which allows people to build apps withoiut much code. This could work, or have a hosted excel online sheet

[Saarek]

Thanks @SteveCampbell , would explain why I cannot find any guides to achieve this. I'll have to look into the whole PowerApps thing, but assume that the cost will be prohibitive.

[SteveCampbell]

Here is webcast I did on the subject:

https://www.youtube.com/watch?v=7KppXpVoEYM

Power Apps is indeed an additional cost:

https://powerapps.microsoft.com/pricing/

Power BI is more designed for business insights, autoML / self service BI. A simpler and more cost effective solution could be something like sharepoint or excel online.