Forum Discussion

senenes1996's avatar
senenes1996
New Member
2 years ago

Excel Rows were not updated on the PowerBI

Hello,

 

I changed SharePoint of the Excel (data source). I updated all data sources of the PowerBi. I copied the path of the file and pasted the data source setting on the PowerBi. After that, I updated the data. Although the excel has 413 rows, the PowerBi reached 412 rows. The last row was not updated. 

 

How can I solve this problem? Every time, when I change the SharePoint of the data source I encounter this problem. This time I could not solve it. 

 

Thank you so much

3 Replies

  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion

    Hi senenes1996 

    is there any error on power query editor after changing data source setting??

    can you see all the like 412 rows on power query ??

     

    Note : make sure other steps are not applied on power query editor.

     

     

     

  • No, I can not see all rows in the power query. I have just noticed that the bound of the table determined as a source does not cover the relevant data. But I could not expand the bound of the related table

    • Uzi2019's avatar
      Uzi2019
      Icon for Community Champion rankCommunity Champion

      Hi senenes1996 
      Can you share the screenshot of what you are trying to explain??