Forum Discussion
is it possible to share workspace with external users via API
We are currently using Power BI Report Server internally, so don't have much experience with the cloud offering.
We are looking to share some data with our clients and was looking at the possibility of using power bi pro workspaces to achieve this.
The user only wants the data so would want to grab it via an API.
I was reading about Power BI embedded, would this be the right path? It does seem to indicate registering an app to gain API access, but I ran into access issues which I am waiting for the admin to grant permission to register apps.
Ideally I was hoping to be able to load up the data daily for all the relevant clients, then using their power bi logon, they use the API to grab data relevant to them.
Is this feasible? Our development team don't have time to build a bespoke API, I figured we might be able to leverage the azure platform to do it quickly and without costing too much.
Alternatively if there is already a best practise to do something like this, please let me know.
Thanks for reading
5 Replies
- GilbertQ
Super User
Hi jonjoseph
Currently there is a way to export data from your Power BI dataset from the Power BI Service. There are limitations as shown below.
Power BI Embedded is when you want to embed your Power BI reports into another application. It does not provide a way to create an API to extract data.
If you are looking to simply extract data via an API unfortunately Power BI I feel is not the right solution.
- aj1973
Community Champion
Hi jonjoseph
You should find your answer here
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-azure-ad-b2b
Hi aj1973
Thanks for responding to my query. Is this available if both are just Power BI Pro users without azure?
Is there an API that the external user can use to access the data?
The only API references I have found are related to administering the invites on my side. It doesnt help that most of the things are locked down for me as we are just establishing a cloud footprint.
I did find Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn which allows the user to query the dataset but it has limitations on the data.
I'm assuming theres a best practice approach for this, as it must be fairly common use case.
Thanks
