Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Rich_P_G

Tables nolonger importing from excel

Submitted by Helper I on ‎11-21-2018 05:02 AM

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 in col Z (one cell only) it now pulls through columns A-Z. This cant be right can it?!? I am also unable to see my named tables when I attempt to import. Instead, I have to select the tab name.

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎11-21-2018 10:22 PM

Hi @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 

Idea Statuses