Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
reast
Helper II
Helper II

Random Review

Maybe this isn't possible with Power BI, but I wanted to see if anyone had any ideas. We would like to have clients randomly selected for discussion in group supervision and then removed from the list until all clients had been discussed. I know how to use the random number generator to get a random list, but does anyone know how a client could be checked to indicate that s/he had been discussed? Right now, I'm generating the random list and copying it into Excel for the group to work through, but we are always getting new clients that should be added to the mix and other clients leaving that should be removed. Any suggestions would be greatly appreciated. Thank you!

1 ACCEPTED SOLUTION
Phil_Seamark
Employee
Employee

Hi @reast, if you build a PowerApp (easy to build), you can embed the app into your Power BI report.  This can provide a way for users of your reports to write data out to a place that you can pick up and use in other places.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Phil_Seamark
Employee
Employee

Hi @reast, if you build a PowerApp (easy to build), you can embed the app into your Power BI report.  This can provide a way for users of your reports to write data out to a place that you can pick up and use in other places.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Thank you. I'd never used Power Apps and have been able to set up a Flow that Asks in Power Apps and adds rows to a dataset in Power BI API streaming data. I just can't seem to get the API data back into the Power BI desktop to remove the those clients already reviewed from the random review list. When I try to Get Data from Power BI Service, it says the connect live data option is not available because it already contains data from another source. Any suggestions would be appreciated. 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors