Forum Discussion

Hannah13's avatar
Hannah13
Regular Visitor
6 years ago
Solved

Changing data source from copied report

Hi All

 

I've copied a report from one workspace to another. I've also moved the underlying data (in excel) to a new location.

I've created a dataset in the new workspace from the excel report. I'm trying to change the data source of the copied report to the dataset in the new workspace.

The report was created in Power BI service and it isn't allowing me to download a pbix file.

 

Is it possible to change the data source? It's exactly the same data and I'd rather not have to rebuild the report again.

 

Thanks!

Need Help
Show and Tell
Tutorial Requests
  • Hannah13's avatar
    Hannah13
    6 years ago

    Hi

     

    It's in a different workspace. In the end i've just created the report again from scratch in the new workspace. I find how Power BI service and desktop interact to be quite user un-friendly and frustrating! I'm hoping some changes can be made in the future to make it more seamless!

     

    Thanks for your suggestions.

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    You will need to download the PBIX and change it in Power Query by editing the Source line.

    • Hannah13's avatar
      Hannah13
      Regular Visitor
      6 years ago

      Hi Greg

       

      Thanks for your reply. I am unable to download the PBIX (it is greyed out). Can I download it if the report wasn't created on desktop?

       

      Thanks

      • Icey's avatar
        Icey
        Community Support
        6 years ago

        Hi Hannah13 ,

         

        Based on my test, if the copied report is in the same workspace of the original report, it could be downloaded as .pbix file to local.

         

         

        Best Regards,

        Icey

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.