Forum Discussion

cwstad's avatar
cwstad
Frequent Visitor
9 years ago

Updating a data set

Hi all, I'm currently working on an excel data set, and have forgotten to include some groups from the excel file

 

I have already created the graphs, but is there a way to import the new data and maintain / update the graph data

 

Thanks

4 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee

    Hi cwstad,

    You can import and create a template by clicking->File->Export->Power BI template. 

    After that, Power BI Desktop report as a template (PBIT file), which can be instantiated as a new Power BI Desktop report (PBIX file). You can import the template,either via double-click on the PBIT file, or by using the “File –> Import –> Power BI Template” path, a new Power BI Desktop file will be created, containing the actual data based on current user’s credentials for data sources, etc.



    For more details, please refer to this article. And here is a thread which will help understand it.

    Best Regards,
    Angelia

     

  • Just Refresh the PowerBI (if same file name and path)

    edit queries, then advance query, then change path (if diff path/name)

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee

    Hi cwstad,

    Have you resolved your issue? If you have, please mark the corresponding reply as answer. If you have not, please feel free to ask.

    Thanks,
    Angelia

    • cwstad's avatar
      cwstad
      Frequent Visitor

      Hi i was looking to use a different data set and keep the graphs

       

      I tried the template, but it still kept the original data

       

      I deally i want to keep the graphs only as import the data set from excel

       

      thanks