Do Business users have capability to upload the list of the column values to Power BI

[Anonymous]

End Users want to use self-service option out of the dataset that we built out of datawarehouse, does the users have the capability to upload a list of column values to be used as the primary selection criteria argument for the resulting report?

Please give your suggestion.

[Anonymous]

Thanks! for your response,

we achieved this by embeding a Button on report with sharepoint URL directing users to a sharepoint List where users can enter the values in csv format and we are using dataflow with sharepoint list as source and we have split the values by comma delimiter(power query editor) and have a join with redshift table and filter out the values on the template list.

we are using Power Automate(to detect change in sharepoint and trigger dataflow refresh and send an email to user), we have created a Flow(with 3 steps) to detect the changes in sharepoint(create or modify list) and refresh the dataflow and finally send an email alert to user saying the values are available in dataset and to refresh the report.

we have used a scroller visual on bottom of the template report to convey a message to user saying "click on button and upload the values and wait for an email alert".

Now we are stuck at 

We have gateway configured for redshift datasource refresh(incremental) and when we schedule the refresh the refresh fails with error.

Data source error:	Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
Cluster URI:	-redirect.analysis.windows.net
Activity ID:	89fde175-e5ac-4110-a6d4-4c687e574a86
Request ID:	a27edc31-987e-4f01-b713-afbb9dd64d9c
Time:	2022-07-05 13:04:29Z

[Anonymous]

Thank you! for the response, can we upload those values and see the desired data from power bi service page?

when there are multiple users how the sharepoint file will fit in? 

[lbendlin]

Have you tried it? Where are you stuck?

[lbendlin]

Use a BMT (Business Managed Table) for example an Excel file on a Sharepoint where users can specify the desired columns.

Then use the new Field Paramters feature to add these columns dymanically

And finally enable the Personalize Visuals feature (and teach your users how to use it) which may make all of the above look like child's play.