Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Re-import Queries and Model from Excel without deleting the reports

Hi friends,

I have imported Queries and Model from Excel file and built reports in Desktop

Now I have slightly changed a model in Excel so it shouldn't affect the reports

When I Import again to Desktop - it deletes the reports

Please help

Thanks

Michael

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Anonymous

     

    When importing Excel Workbook into Power BI Desktop, once the data model is loaded into the Power BI Desktop file has no dependence on the original Excel workbook, and can be modified or changed (and saved, and shared) without affecting the original workbook. So whatever structural changes in your source workbook model (like adding tables) can't be updated into .pbix. You have to re-import it.

     

    Reference:
    Import Excel workbooks into Power BI Desktop

     

    Regards,

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Anonymous

     

    Check if there is change in the column names and the data types in the data model .

     

    Cheers

     

    CheenuSing

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Anonymous

     

    When importing Excel Workbook into Power BI Desktop, once the data model is loaded into the Power BI Desktop file has no dependence on the original Excel workbook, and can be modified or changed (and saved, and shared) without affecting the original workbook. So whatever structural changes in your source workbook model (like adding tables) can't be updated into .pbix. You have to re-import it.

     

    Reference:
    Import Excel workbooks into Power BI Desktop

     

    Regards,

  • tringuyenminh92's avatar
    tringuyenminh92
    Icon for Memorable Member rankMemorable Member
    9 years ago

    Hi Anonymous,

     

    v-sihou-msftis correct, so you should not remove or modify header name of data model in excel.

    but I would like to add one additional information that you could add new columns/fields in excel and refresh your data model in Query Editor, it will add new columns for you. I think this is change in excel model that PBI Query Editor supports to reflect.