Forum Discussion
Refresh error due to blanks in key column
Hello! I´m having troube refreshing my PBI Desktop model. It just contains data from an Excel file. I updated de Excel file and now it has less rows. Then I tried to refresh and this is what appe...
Hello @pedrocordova
The Power Query query might detect more rows than necessary. Select the key column in Power Query, click the filter drop-down list, and delete the null or (blank) values.
That way you don't have to go back and edit the Excel file. The goal is to do 100% of the work in Power Query so you don't have to do manually and redo manual transformations.
edhans
Community Champion
Community ChampionHello @pedrocordova
The Power Query query might detect more rows than necessary. Select the key column in Power Query, click the filter drop-down list, and delete the null or (blank) values.
That way you don't have to go back and edit the Excel file. The goal is to do 100% of the work in Power Query so you don't have to do manually and redo manual transformations.