Power BI

Declined

Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

Vote (435)

Harsha on 03 Jul 2017 11:21:18

Currently each Power BI report published to the Report Server has its own data source embedded within the report. Any change in the source would require us to change hundreds of published reports individually. Could we have a shared data source/connection similar to SSRS Reports that would help us manage deployment and changes much more efficiently.

Administrator on 01 Apr 2019 23:38:54

We're not planning to make this feature available in Power BI Report Server. We are looking at making available an API to allow you to change the data source programatically, however, to make movement between servers easier.

Comments (87)

Comments (87)

9e1e7506 28ed-4558-ad6e-28d91a54332f on 05 Jul 2020 23:23:12

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

I would like this functionality. This function really help having a rock solid data strategy fitting nicely into all the MS BI stack of products

f524e627 8a84-44ae-8be2-7223b9297c8f on 05 Jul 2020 23:22:28

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

Hallo Microsoft,

wir benötigen diese Funktion dringend, um das Produkt in unserem Konzern nach vorn zu bringen und es unseren Kunden zur Verfügung zu stellen.

94699f21 5e2f-4809-83b6-156b9ec6dd6a on 05 Jul 2020 23:21:55

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

We need it ASAP! The scenario where users don't have access to databases with their Windows Users or database users is very common!

40e26cd4 70b9-4fec-9d51-1668ea28fccc on 05 Jul 2020 23:21:45

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

his is a huge need. Please implement this functionality.

176514a6 4e47-4158-bd3c-cc088cf89c0c on 05 Jul 2020 23:21:19

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

I totally agree - Why not just use the .pbit (powerBI template) file as a connector for PowerBI, SSRS & excel? Publish it to a central repository and all tools can connect and deliver aggregated or big dump reports based on this. SSAS Cubes have a model but they are way to slow to use for dump reports since MDX is not designed for this.

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:21:07

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

Very much needed functionality!

c5875302 f143-4606-9d38-92ac55e6101a on 05 Jul 2020 23:20:59

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

Been under review for 10 months now, much needed functionality, please add this on to roadmap asap.

22f4900d 0c5a-4baf-bb36-91fb8eb360b9 on 05 Jul 2020 23:20:51

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

Massive shortcoming having to set the credentials for every report individually.

823494d3 0d89-45db-9ba4-001a90392b4b on 05 Jul 2020 23:20:06

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

This is a huge need. Please implement this functionality.

f623947a 8de5-4af8-b357-7245eed8829a on 05 Jul 2020 23:19:49

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

This is a critical feature! Please implement ASAP.