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 ...
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

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

    Hi v-jiascu-msft,

     

    Thanks for the reply but I don' tthink I have explained myself very well. Let me try again....

     

    We currently have 2 datasets in PowerBI Services, lets call them DEV and PROD. These 2 data sets are identical but 1 pulls from our development database (DEV) and the other pulls from our Production database (PROD).

     

    I have built a report against the DEV dataset which, having tested, validated and agreed with the teams, I now need to re-build to use the PROD data. Naturally re-building this from scratch will take time and could end up in differences in layout ect due to human error.

     

    What I am looking for is a way to disconnect the DEV dataset and connect instead to the PROD dataset. So that I do not need to re-build the report from scratch.

     

    Hope this makes more sense.

     

    Thanks

     

    Danny