Showing results for 
Search instead for 
Did you mean: 
New Member

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

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.


Your guidance is much appreciated.

New Member

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

@amitchandak  Thank you for those links. We are planning to build our application in AWS. Do you think Power BI would be apt or you would suggest us developing custom app using R or Python to do data analysis and visualization?


Also, I dont think I would create any roles as I will have random visitors or users visiting our website and taking the survey. we would need to collect the user data and compare it with the master data in the backend and show some basic level analysis. I still feel there is something I am not understanding. 


The main question is how do I consume user specific data (in our case we will have random visitors in our website taking the survey)? 

Helpful resources


August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors