topic Re: How can I change the data source online in Report Server

How can I change the data source online

tmhalila — Wed, 05 Jul 2023 13:19:38 GMT

Hello team,

How can I change the data source for the Power BI report when it is on the Reporting Server?

Re: How can I change the data source online

KBO — Wed, 05 Jul 2023 15:02:24 GMT

Hi, the Problem with Report Server is you have to set up your data soruce in the Desktop. What would be your exact use case here?

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Re: How can I change the data source online

tmhalila — Thu, 06 Jul 2023 14:01:00 GMT

Sometimes the file is too large to re-upload. Let's say I have two dashboards, the Old version and the New version, both in Report Server. Then I made some changes in the testing database and pushed it to the production database; now I want to change the source of my new dashboard to read from the Production Database

Re: How can I change the data source online

KBO — Thu, 06 Jul 2023 14:04:13 GMT

Ah why didn't you say so try to use parameter for this: https://www.yodabi.com/parametriesieren-von-datenquellen-parameterization-of-data-sources/

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Re: How can I change the data source online

tmhalila — Thu, 06 Jul 2023 14:17:47 GMT

This might be useful in Power BI Service but not in Reporting Server

Re: How can I change the data source online

KBO — Thu, 06 Jul 2023 14:21:28 GMT

Ah thanks for reminding me 🙏

Ok if we are in the Report Server you could use the SSAS to create diffrent environments and simply changing the connection string to the diffrent environments.

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!