Shared Power BI Datasources on server

353 Views Asked by At

our current SSRS setup has Shared Datasources (to SQL server/db) so many reports can use them.

Is such a setup possible in PowerBI?

So A developer can login/use this shared datasource to build their report/db, then publish on the server, and when user executes the report, it uses a service account on that shared datasource?

1

There are 1 best solutions below

2
On

You can produce a dataset in PowerQuery and optionally build out visuals. Once deployed to PowerBI Service you can connect to the dataset from many other PowerBI reports (PBIX files). You also have the option of re-using PowerBI data flows.

enter image description here

Control access using Manage Permissions

enter image description here