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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.