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

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.

    • Hannah13's avatar
      Hannah13
      Regular Visitor
      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.

      • Icey's avatar
        Icey
        Community Support
        6 years ago

        Hi Hannah13 ,

         

        Sorry for the unpleasant experience.

         

        In addition, You can post your idea on Power BI Ideas.
        It is a place for customers to provide feedback about Power BI.
        What's more, if a feedback is highly voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

         

         

        Best Regards,

        Icey