Please find below my responses! We have tried a lot of combinations and validated them. Some of the steps, which work very well in reality, are invalid as per documents or licensing terms.
We would like validation of the same, or advise from expert developers for the same.
"I say It works with Premium capacity instead of Shared Capacity, means your users doesn't need pro in this way." - No, it works very well with Shared Capacity as well. Please check.
"When App workspaces in shared capacity, Any app usage requires a Pro license." - Yes, agreed. Users need Pro license to open the App Workspace in Power BI Service. But they still are able to access the datasets (of the shared workspace) from Power BI Desktop. Is this a bug or expected behavior ?
"If the app workplace is in thePremium capacity,even a free user can open the app workplace." - No, this is not true. Even with Premium workspace, Free users cannot open App Workspace. They can only access the reports (of this Premium workspace) which are shared explicitly with them. Please check.
I will not be able to provide fiddlr trace. I have given sufficient steps and information above which are necessary to replicate the behavior by anyone. We have tried this with at least three users and four machines, it replicates easily.
Request you to take the lead and proceed as per the info available.
As such for our requirement, Power BI Datasets will not be useful for us, and SSAS will be a right solution for us, again requiring added infrastructure investment and maintenance. Sigh!