Forum Discussion

oren's avatar
oren
Helper III
8 years ago
Solved

Update Data in PBI from Excel

hi

 

i have a power bi report with a data source comes from excel. i added new row to the excel and i want to update the data.
i couldn't find any good solution in the forum that explain how to do this.

(i tryed go to "edit Quaries" and change the Source/Navigation" .  it never showed me the new row i added to the excel)

 

 

I would appreciate if somone can help me with a solution
 
thanks a lot 
 
oren 
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi oren,

     

    In both report view mode and query editor mode, there is a Refresh button, please click it manually, the new row will be shown in the loaded dataset.

     

    Regards,

    Yuliana Gu

2 Replies

  • oren's avatar
    oren
    Helper III
    8 years ago

    hi

     

    i have a power bi report with a data source comes from excel. i added new row to the excel and i want to update the data.
    i couldn't find any good solution in the forum that explain how to do this.

    (i tryed go to "edit Quaries" and change the Source/Navigation" .  it never showed me the new row i added to the excel)

     

     

    I would appreciate if somone can help me with a solution
     
    thanks a lot 
     
    oren 
  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi oren,

     

    In both report view mode and query editor mode, there is a Refresh button, please click it manually, the new row will be shown in the loaded dataset.

     

    Regards,

    Yuliana Gu