Forum Discussion
Anonymous
6 years agoNot applicable
Keep blank columns when import excel sheet
Hi, someone can help me with this:
I have to import the same sheet from differets paths, so I´ve created a function that do that and extract the third column but sometimes the sheet have the first column blank and power query imported from column B not from column A (because column A is blank). Can I keep all columns when I imported sheet?
I want to import all the columns including the empty columns (power query delete automatically) or the first 50 columns.
Hi Anonymous ,
You could use Ctrl+T to create a table range in Excel. Then import it in Power BI.
2 Replies
- lbendlinSuper User
Before you "Promote Headers" make sure that all columns have a value in the first row.
- v-eachen-msftCommunity Support
Hi Anonymous ,
You could use Ctrl+T to create a table range in Excel. Then import it in Power BI.