Forum Discussion

laserkiwi's avatar
laserkiwi
Frequent Visitor
8 years ago

Save as / migration options?

Hi,

 

I'm finding Power BI a little frustrating in terms of the workflow required to re-use existing reports and/or datasets. Perhaps I'm missing something so if anyone has any suggestions for me to improve my workflow and keep it as DRY as possible, I'd be totally grateful.

 

I always use the most recent version of Power BI Desktop, although I've found older reports don't always have the current functionality available when re-opened in PBI Desktop, compared to creating a new file in Power BI.

 

Is there any other way to migrate visual elements, measures, the data model, etc, from an existing report, to a new report where all functionality is available other than re-creating it manually?

 

Today I want to make a new report from an existing data model. I have a copy of my pbix with only a blank page in the front end, but it's the old-style pages (no dotted boundry & improved layout options). I want to take advantage of the updated features.

 

The data model has 57 queries in it, and I'm facing the task of having to open Advanced Editorand copy & paste the code for each one individually into my new report, and then I've got about 30 measures to re-create.

 

I speed things up with the latter using DAX Studio to export my measures to Excel so I can fire through copying & pasting them, but there's got to be a better way than this?

 

Thanks in advance for any ideas!

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Is there any better solution available for this yet?

      • Wimverh's avatar
        Wimverh
        Resolver IV

        You can reuse the entire datamodel, and copy visuals from the source pbix to the new pbix. 

        Step 1: Publish your source file to powerbi.com from the desktop
        Step 2: Open a new power bi desktop
        Step 3: Connect to a power bi dataset

        Step 4: navigate to your dataset of the previous published report

        You can now use the linked datamodel.