Forum Discussion
Edit/create with app owns data
Anonymous - Correct, you have to create your own workspaces with Power BI Embedded, it isn't built in that every user gets a workspace. But, remember, you are writing your own application on top of Power BI Embedded. You can add an "Edit" button that, for example,
- Creates a new workspace for the user if it does not already exist
- Stores an attribute in the SQL database for the application for this user's workspace
- Copies the report to the workspace
- Opens the report in edit mode
Anonymous - So, in Apps owns data, that just means that your application is handling the authentication to Power BI because that is handled via an access token under the hood. You can still do authentication in your app and pass that information along. I just sat through a whole thing on Power BI Embedded a little while ago and was doing a bunch of research. As I recall, you could have a report available and when you "edit" it, you actually save the report to a workspace for that user and let them edit it there and save it. So, you wouldn't necessarily have to overwrite the report.
But what is the "workspace for that user" ?
According to this link https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal-certificate "My Workspace" isn't supported when using service principle.
So where should the user store the edited version of the report? In the same workspace? But in this case, it will be not possible for the user to access this version once again, as the implemented call (e.g. within the website) always leads to the original report...
It is clear for me, how it will work, if we call the report in the view mode, but I dont understand, what is the idea behind the edit and create modes.
Anonymous - Correct, you have to create your own workspaces with Power BI Embedded, it isn't built in that every user gets a workspace. But, remember, you are writing your own application on top of Power BI Embedded. You can add an "Edit" button that, for example,
- Creates a new workspace for the user if it does not already exist
- Stores an attribute in the SQL database for the application for this user's workspace
- Copies the report to the workspace
- Opens the report in edit mode
Greg_Deckler : Thank you, Greg! It is getting much more clear for me.
One more thing :
Is it true, that we cannot use "My Workspace" within the app owns data option?
So in the case, if I want to provide the endusers with the possibility to create own reports in theier own workspaces, i need to create this workspaces.
Alternatively I'm also able to use user owns data option, as it is possible for me, to create AAD accounts for this users. Then the users could simple use their own "My Workspace" within the powerbi.com. Not sure, if I it also possible to access "My Workspace" through API, as it does not have any ID?