different reports for different users - Power BI Embedded App Owns Data

[orforf]

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 and then I would store the report ID and userId together then when the user would like to retrieve the report a call would be made to the api through the power bi tenant to retrieve the reports for the user.

My question; am i heading in the right direction, how scalable is this and what are some limitations I might come across?

[TedPattison · Accepted solution]

I think there are two designs you could use.

1. 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.
   
   
2. 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.

[orforf]

Thanks for your response Ted

The app workspace for each user seems like the right approach for me.