In the latest PBI update, its nolonger recognising defined tables within a spreadsheet tab, and instead pulls in anything it sees. For example, if my table is set to cols A-E, but there is a comment ...
v-qiuyu-msft
Community Support
Community SupportHi Rich_P_G,
I have tested with Power BI desktop latest version 2.64.5285.741 64-bit (November 2018) but not reproduce the issue. In your scenario, please check if the table range in Excel is correct. After renaming table, please save and close the Excel file then get data in Power BI desktop again.
If issue persists, please share Excel file with us. You can upload it to your OneDrive and send the share link to me via private message.
Best Regards,
Qiuyun Yu