Forum Discussion
User input saved within Power BI Table
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.
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
3 Replies
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
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.
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.
