Edit/create with app owns data

[Anonymous]

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

[Greg_Deckler]

@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.

[Anonymous]

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.

[Greg_Deckler · Accepted solution]

@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,

1. Creates a new workspace for the user if it does not already exist
2. Stores an attribute in the SQL database for the application for this user's workspace
3. Copies the report to the workspace
4. Opens the report in edit mode

https://community.powerbi.com/t5/Developer/Create-workspace-in-Power-BI-Embedded-using-Rest-API/td-p/390750

[Anonymous]

@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?

[Greg_Deckler]

@Anonymous - So yes to the first question. Second question yes, but I do not know about accessing it via the API.