text boxes

[whereismydata]

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

[lbendlin]

An Excel file on a SharePoint is an acceptable option for a business managed table.

[whereismydata]

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

[lbendlin]

Are you talking about on-premise SharePoint?

[whereismydata]

no, sharepoint online. I do not want to be dependend on users credentials

[lbendlin]

Don't you use OAUTH2?

[whereismydata]

Hi @lbendlin ,
well I guess yes, so OAUTH2 is Token based and therefore a password change will not affect the connection? How long does the token stay valid?

[lbendlin]

Take your token and throw it at jwt.io  - it will tell you the validity period.

[whereismydata]

hi @lbendlin, first let me thank you for taking time answering my noob questions.
Unfortunatelly I do have another one. I created a connection to a sharepoint list and I can see in the configuration settings that OAuth2 is selected.

Can you guide me on how to get the token?

thanks

[lbendlin]

Interact with your SharePoint and monitor the network traffic. The token is part of the payload.