Forum Discussion

Toast36's avatar
Toast36
Icon for Helper I rankHelper I
8 years ago

Moving a report from Development to Live......

Hi all,

 

So here's the situation. I have been developing a data set using our Dev databases which is now ready to be moved to live. The dataset sits on services and I've created report in desktop using that datasaet as the data source. The problem is that I don't want to have to re-create the entire report from scratch with the new dataset I would prefer to take a copy of the Dev report and repoint it to the Production Dataset instead.

 

I know that I could just point the DEV dataset to pull data from the Live database but I still need a dev dataset for other work.

 

Is there a way to do this using the Desktop application?

 

Thanks

 

Danny

4 Replies

  • quentin_vigne's avatar
    quentin_vigne
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hi Toast36

     

    Yes you can do that very easily ! 

     

    Go to file > Options and settings > Data Source Settings > Right click data source > Change data source

     

    - Quentin

    • Toast36's avatar
      Toast36
      Icon for Helper I rankHelper I
      8 years ago

      Whilst that would allow me to re-point the data source to use a different connection string it doesn't seem to allow me to change the datasource used within the report.

       

      As the report that I want to re-point has been built using a PowerBI Services dataset there is no Data Source saved in the report.

       

      What I want to do is update this report to pull from a different PowerBI Services dataset, rather than changing the data source for that dataset.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi Toast36,

         

        If you switch from one Power BI Services dataset to another Power BI Services dataset, the report still can be updated. If I understand your scenario correctly, you want to pull data from more than one dataset. I would suggest you create an idea here. 

         

        Best Regards,

        Dale