Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
Hi @Anonymous ,
You could use Ctrl+T to create a table range in Excel. Then import it in Power BI.
Hi @Anonymous ,
You could use Ctrl+T to create a table range in Excel. Then import it in Power BI.
Before you "Promote Headers" make sure that all columns have a value in the first row.