Forum Discussion

tmhalila's avatar
tmhalila
Resolver II
3 years ago
Solved

How can I change the data source online

Hello team,

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

 

  • KBO's avatar
    KBO
    3 years ago

    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!

5 Replies

  • KBO's avatar
    KBO
    Memorable Member

    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!

    • tmhalila's avatar
      tmhalila
      Resolver II

      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