Getting user session data from website and displaying dynamic power BI report in the website

[Anonymous]

Hello Guys,

I am a product manager for a boutique management consulting firm, and we are trying to develop a benchmark reporting tool or platform. I am very new to power bi, and in the exploration phase. We are currently trying to figure out a solution before approaching the engineering team. Below is the requirement:

End-User logs in to our website -----> Takes a survey in a form -----> the system needs to capture the user session and survey data ----> The captured data gets stored it in the backend system (DB) -----> Power BI fetches the data and computes -----> The dynamic report from power BI is displayed back into our website for the same user session.

Can we integrate power bi into our website to generate dynamic real-time reports based on the real-time data end-user provides? For example - if there are 500 end-users visiting our platform and taking the survey at the same time, can power BI produce real-time dynamic reports for each and every user based on the survey that they take?

I know there is functionality like row-level security, but, I feel that is not adequate for this scenario.

[v-deddai1-msft]

Hi @Anonymous ,

Your requirements look like Q&A visualization. Please refer to https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-q-and-a

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[GilbertQ]

Hi there

This could be down where you can use Power BI Embedded and then using DirectQuery you could query the DB based on the same user details to display their data?