Google Sheets values are shifting to unintended column

[aweaver]

Hello,

When I import my information seperated by 4 distinct tabs into Power BI, I have information being shifted into the next column. I have gone back and looked at the source data and the problem does not lye there. It is also picking up on columns that do not appear to have any data. It also does not act this way for all of my sheets. Has anyone else encountered this? 

[v-chuncz-msft · Accepted solution]

@aweaver 

You may take a look at the post below and check The Advanced Editor.

https://community.powerbi.com/t5/Integrations-with-Files-and/How-to-connect-google-sheet-to-Power-BI...