cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

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



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



View solution in original post

3 REPLIES 3
Highlighted
Super User I
Super User I

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



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



View solution in original post

Highlighted

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.

Highlighted

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.



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors