Skip to main content

Power BI

Under Review

Re-pointing reports/dashboards at different data sources

Vote (247) Share
Nithya Subramaniam's profile image

Nithya Subramaniam on 25 Mar 2015 10:16:45

Ability to build reports/dashboards pointing to a data source (database in the Development / UAT machine) and then use the same reports/dashboards pointing to another data source (in the Production machine.

Comments (36)
Nithya Subramaniam's profile image Profile Picture

a51ae44c 2c4c-44ea-830a-e4be93fed817 on 06 Jul 2020 00:10:57

RE: Re-pointing reports/dashboards at different data sources

We need to be able to point a report / dashboard at a different container in Blob storage. The file names and types (either CSV or XML per Msft recommendation) reside in a different container for a different client. How does an organization REUSE that report / dashboard against a different cotainer?!

Nithya Subramaniam's profile image Profile Picture

07ab4c00 53a0-49e9-8e5d-6417ed3a4cfe on 06 Jul 2020 00:09:21

RE: Re-pointing reports/dashboards at different data sources

This would be so big - would be great to see this!

Nithya Subramaniam's profile image Profile Picture

1bc5a90c 5934-4b6d-9e14-669ecd638963 on 05 Jul 2020 23:52:42

RE: Re-pointing reports/dashboards at different data sources

I have 100 internal customers who all need the same dashboards/reports just with a different data source. Is there a way to re-use dashboards?

Nithya Subramaniam's profile image Profile Picture

e6a820b1 c99a-47fd-8a72-7d71b912b08d on 05 Jul 2020 23:43:19

RE: Re-pointing reports/dashboards at different data sources

It is very time consuming to make dashboards and them change the source manually.

Nithya Subramaniam's profile image Profile Picture

c32c3b5b 0c4e-42fa-971d-da6ce5a1ff63 on 05 Jul 2020 23:35:38

RE: Re-pointing reports/dashboards at different data sources

We are just beginning to roll out PBIRS and our first clients are hitting this issue. They cannot access production systems, so an admin (me) has to pull their reports into Desktop, change the data source credentials, and re-upload. Very time-consuming and not a big confidence-builder for our client.

Nithya Subramaniam's profile image Profile Picture

a50605d7 a7d6-4ef7-963c-3873a5608ab7 on 05 Jul 2020 23:31:49

RE: Re-pointing reports/dashboards at different data sources

Can't this be done already by using parameters to define your connection string?

https://biinsight.com/power-bi-desktop-query-parameters-part-1/

Nithya Subramaniam's profile image Profile Picture

2e625342 483c-475e-91e9-7dd546428e99 on 05 Jul 2020 23:26:14

RE: Re-pointing reports/dashboards at different data sources

Interested in the progress with this issue? This is definitely a basic BI requirement.

Nithya Subramaniam's profile image Profile Picture

a084f61b 5b26-43f8-b756-876e9630c7c5 on 05 Jul 2020 23:23:23

RE: Re-pointing reports/dashboards at different data sources

Is this something that is available now in PowerBI?

Nithya Subramaniam's profile image Profile Picture

d1703fce 1de6-4346-b128-737ad2a6f4a6 on 05 Jul 2020 23:18:20

RE: Re-pointing reports/dashboards at different data sources

Please do something about this.

We should not be redeveloping everything when moving from PROD - UAT - DEV...

Nithya Subramaniam's profile image Profile Picture

a8b2bbbf 8afc-40bc-8406-087d319df8d4 on 05 Jul 2020 23:08:40

RE: Re-pointing reports/dashboards at different data sources

Facing the same challenges.