Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I was wondering if it is possible in power bi to allow users to pick a date, type in a value and then populate a table with that date and value in a live published report? The purpose of this is that each week based on production demands our plant peak energy demand changes. I want users to be able to enter an estimated value for that specific saturday for example and then compare that estimate with the actual energy consumption. Any help would be appreciated.
Thanks
Solved! Go to Solution.
Hi @ameerehs,
It is possible. There are a few dependencies and a couple of issues to overcome.
I'll run through what I've found and you can decide whether it is worth your time to investigate further.
What I did
Caveats/Issues
but I very quickly ran into the 'refresh in a 24 hour period limitation' of 8, you'd have 48 if you have premium.
Thoughts
If you can share a copy of the report, or sample of it, it may be easier to offer a more definitive solution.
Hope you get some use out of this.
Regards,
Kim
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Hi @ameerehs,
It is possible. There are a few dependencies and a couple of issues to overcome.
I'll run through what I've found and you can decide whether it is worth your time to investigate further.
What I did
Caveats/Issues
but I very quickly ran into the 'refresh in a 24 hour period limitation' of 8, you'd have 48 if you have premium.
Thoughts
If you can share a copy of the report, or sample of it, it may be easier to offer a more definitive solution.
Hope you get some use out of this.
Regards,
Kim
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Hello.
I hope this message finds you well.
I was trying to find a solution similar to the one in this post and I found your solution very very interesting. I was wondering if you have tried it out and if it was a successful one. I would greatly appreciate any guidance or help in this matter.
Thank you in advance!
Hi @Dimitris_Kats,
The process I outlined works. It depends on whether any of the issues I mentioned are a problem.
If you create a new post and tag me in it I can take a look. I have limited time available so if you keep the questions specific I'll do my best to help.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
@KNP thank you very much for replying to me.
I have a quick question. My dataset is connected to a SQL server but it's not possible to have a gateway for the refresh of the dataset . I am refreshing the dataset manually.
Is this going to cause trouble with the power automate??If yes, Is a way to work around ??
Is there any other way to enable open text comments without using Power apps??
Thank you very much in advance
🙏🙏🙏
Without a gateway, I don't see a way to get the refresh portion of the flow to work.
Probably need more specifics to assist.
Best to do it in a new thread.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Thank you very much. Your help is greatly appreciated 🙏
@ameerehs
I am pretty sure it is not possible to input data to populate a table in Power BI. You may only create the table in the report first, and create slicers for date column, type column or others columns. Then you can just filter with existing options in the slicer rather than Inputting.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@ameerehs , You can use whatif parameter
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
You have republish the file. or use ALM toolkit for partial publish
@amitchandak thanks for the reply, however im not sure if the what if parameter will help me out in this situation. How will the whatif parameter be able to populate a table and have that input for a specific day. Not sure if Im explaining what I'm looking to do correctly.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |