How to get new added measure from excel data model in PBI desktop without recreate exists report ?

[Lee_Lv]

Hi, I'm new, tried to find same issue on community but couldn't, please help.

Following is my steps.

    1. I create table, query, add "Measure 1" in Power Pivot in excel file then refresh all in workbook.
    2. Open PBI desktop, use import -> Power Query, Power Pivot, Power View -> choose excel file -> Keep connection.
    3. Everything loaded include data and "Measure 1".
    4. I added new data and new "Measure 2" in Power Pivot in excel file then refresh all in workbook, save file.
    5. Refresh in PBI desktop, new data added but "Measure 2" didn't appear in PBI desktop.

Tried publish from PBI desktop and refresh dataset online, but didn't work, new added Measure will not appear in report if need keep report.

Is PBI doesn't refresh new added measure for a exist report or my operation isn't correct, please help.

[negi007 · Accepted solution]

@Lee_Lv Once you have imported your powerpivot file into powerbi desktop, any change you make in your excel file will not reflect in the powerbi desktop file. Your powerbi import data only once from the excel file using import option. Once imported it has no dependecny on the original file.

Power BI Desktop analyzes the workbook and converts it into a Power BI Desktop file (.pbix). This action is a one-time event; once the Power BI Desktop file is created with these steps, the Power BI Desktop file has no dependence on the original Excel workbook, and can be modified, saved, and shared without affecting the original workbook.

After the import is finished, a summary page appears that describes the items that were converted, and also lists any items that couldn't be imported.

pl. refer to below documentation for further help.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-import-excel-workbooks

[negi007 · Accepted solution]

@Lee_Lv Once you have imported your powerpivot file into powerbi desktop, any change you make in your excel file will not reflect in the powerbi desktop file. Your powerbi import data only once from the excel file using import option. Once imported it has no dependecny on the original file.

Power BI Desktop analyzes the workbook and converts it into a Power BI Desktop file (.pbix). This action is a one-time event; once the Power BI Desktop file is created with these steps, the Power BI Desktop file has no dependence on the original Excel workbook, and can be modified, saved, and shared without affecting the original workbook.

After the import is finished, a summary page appears that describes the items that were converted, and also lists any items that couldn't be imported.

pl. refer to below documentation for further help.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-import-excel-workbooks

[Lee_Lv]

Thank you for the answer.

Do you know is there a way could fully connect PBI and excel file, I mean synchronize all elements include any additional measure after refresh in PBI ?

[Lee_Lv · Accepted solution]

Found.
Import excel file from one drive could synchronize all elements.