Forum Discussion
text boxes
Hi,
following problem:
I want to show some text in a text box that changes with the filter context.
the report shows data of a selected scenario. The scenarios are constantly changing (outdated ones are deleted, new ones are added). The key user should be able to enter text in some form that interprets the scenario.
scenario_table:
| scenario_name | some_data |
| scenario_a | 123 |
| scenario_b | 456 |
since this is an constantly changing report, I do not think it is wise to use bookmarks and prefilled textboxes. So some form of external datasource is recommended.
lessons_learned_table
| scenario_name | lesson_learned |
| scenario_a | this worked best |
| scenario_b | this one was bad |
so of course, a simple excel workbook would be fine, but I'm not a huge fan of excel as a data source.
then sharepoint comes to my mind. also in conjunction with power automate to automatically update the sharepoint list with new scenarios. downside of this approach is the need of a user account and the need of updating the password quite frequently (not sure if I can use service accounts for this, I tried using app secrets, but thats now beeing blocked by our IT).
what is your approach to my issue?
thanks
9 Replies
An Excel file on a SharePoint is an acceptable option for a business managed table.
hi lbendlin ,
how do you handle credentials? Do you let the user log in and update the password every now and then when it is required or does PowerBI ignore password changes? I somehow observed such behaviour with power automate.
thanks
best
Are you talking about on-premise SharePoint?
