Forum Discussion
Edit/create with app owns data
If we are going to use Apps owns data way to implement Power BI Embedded, it will be possible for , say, 100 customers to access the reports without any authentication.
Moreover it is possible not only to show the report in view mode, but also in edit mode or even to allow to create a new one.
So if the edit mode is allowed and one of the customer changes and saves this report, where the report will be stored?
Will the report be overwritten and all other 99 customers will see the changed version?
I dont really understand the way, how the edit and create modes should be used in case of Apps owns data implementation...
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
5 Replies
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