Forum Discussion
different reports for different users - Power BI Embedded App Owns Data
How would i go about allowing my users to create and use their own personal custom reports inside an application. At the moment on a basic level I can see it working as the user creates a report ...
I think there are two designs you could use.
- Create a new app workspace for each user. That way you can easily save and load reports for each user without having to track out-of-band info in a DB to associated users with their reports. Yes, you might be creating 100s of app workspaces - but it can be managed and scaled using code to automate creation and maintance. This approach will become more attractive once Microsoft begins to support datasets that can be shared across app workspaces.
- Create a single app workspace and also create an underlying database so you can track which reports are owned by each user. I am not sure what the limit is to the number of reports that can be stored in a single app workspace. However, I think managing content through the standard Power BI portal at https://app.powerbi.com would get tricky once you have 100s of reports. Therefore, you might need to created a custom application to manage content for users who have created reports.
- Create a new app workspace for each user. That way you can easily save and load reports for each user without having to track out-of-band info in a DB to associated users with their reports. Yes, you might be creating 100s of app workspaces - but it can be managed and scaled using code to automate creation and maintance. This approach will become more attractive once Microsoft begins to support datasets that can be shared across app workspaces.
I think there are two designs you could use.
- Create a new app workspace for each user. That way you can easily save and load reports for each user without having to track out-of-band info in a DB to associated users with their reports. Yes, you might be creating 100s of app workspaces - but it can be managed and scaled using code to automate creation and maintance. This approach will become more attractive once Microsoft begins to support datasets that can be shared across app workspaces.
- Create a single app workspace and also create an underlying database so you can track which reports are owned by each user. I am not sure what the limit is to the number of reports that can be stored in a single app workspace. However, I think managing content through the standard Power BI portal at https://app.powerbi.com would get tricky once you have 100s of reports. Therefore, you might need to created a custom application to manage content for users who have created reports.
Thanks for your response Ted
The app workspace for each user seems like the right approach for me.