Forum Discussion
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.
2 Replies
Anonymous , You can connect. The option connects to DB, Rest API, Feed etc.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources
rest API - https://community.powerbi.com/t5/Power-Query/Pull-data-from-a-REST-API-Authentication/td-p/246006
Rest API
https://community.powerbi.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400
https://www.progress.com/tutorials/odbc/directquery-your-custom-rest-api-in-power-bi
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/RLS - Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-biamitchandak 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)?
