is it possible to share workspace with external users via API

[jonjoseph]

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

[aj1973]

Hi @jonjoseph 

You should find your answer here

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-azure-ad-b2b

[jonjoseph]

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

[aj1973]

Hi @jonjoseph 

In order for the external user to be able to access and use Power BI APIs , the user must be registered in Azure AD as a Guest and Grant access by the Tenant. Yes you need Azure AD 

[GilbertQ]

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.

Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate | Microsoft Po...

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.

[jonjoseph]

Hi @GilbertQ 

Fair enough, I don't have any cloud experience as we are now only starting to establish a presence. 

As it seems like a fairly standard use case scenario, do you know how I can leverage the cloud to achieve this?

Thanks