A simple solution to get one value

[Harris]

I’m looking for a solution to get one value from the user.

My goal is to provide e.g. a form in ms forms and to read data from it in power bi. Do you know any other simple method? If not, how do you get the data from ms forms to power bi? I can’t do it in dashboard only in power bi desktop because I have other data there too.

[Melissa]

Hi @Harris,

Okay so there are limited ways to interact with the datamodel. The most simple one would be a What if parameter, where you set the boundaries and the user can select a value.

But if that doesn’t cover your needs you are down to either Forms or Power Apps in combination with a Streaming dataset.

You can find some links in this thread.

PowerApps and Power BI - Refresh data speed

Hi @uriah1977, No personal experience at this time but have you looked into streaming datasets? Here’s an example using Microsoft Forms but you could use Power Apps instead if that is required.

I hope this is helpful

[uriah1977]

Hi @Harris,

You could export the MS Forms results to Excel and connect to the Excel sheet from PBI Desktop.

Hope it helps.

Daniël

[EnterpriseDNA]

Hi @Harris, we’ve noticed that no response has been received from you since 13th of February. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!