Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
senenes1996
New Member

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 3
senenes1996
New Member

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

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

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Uzi2019
Super User
Super User

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.

 

Uzi2019_0-1714387626682.png

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.