Thanks for your time reading this and hope I can retribute afterwards with some of my knowledge. At this point, you don’t need to do anything more. The ‘Convert Text to Columns’ wizard will appear. From the Data menu ribbon, select the ‘Text to Columns’ button. I would mean the world to me to learn how to fix this. Here’s how you can use this feature: Select the range of cells that you want to convert (remove apostrophes from). But if you are planning to import your spreadsheet to some other application (such as Microsoft Access) then these pesky blank rows make your life painful. Although deliberate inserting of empty rows can sometimes make your reports easier to read and understand. I've found solutions that refer to extra empty rows which is not my case, and this seems to be an easy fix by removing empties from the power query.Īlso the other subject is when a new (real) column is added on the excel I get an error on the refresh because the new column replaces an empty column.Īny help provided will be greatly appreciated. Blank rows or blank cells in data sheets can be very annoying. I've navigated our vast internet source of information and have not found the right solution to fix the extra empty columns, that started with 3, now I have 10+ columns on the dataset. I've been in PowerBI since last 5 years with databases directly, and have managed myself to work it out, anyhow started working with Excel files stored at OneDrive and I've noticed several inconsistencies when importing or refreshing (scheduled and non-scheduled) data from EXCEL, either on Desktop or a Published version from the Desktop one.
0 Comments
Leave a Reply. |