Question for the ninjas here...
I have 31 excel sheets linked in Power Query where I have created an Append with all the data in it. I can view the successful Append in Power Query editor.
When I open Power Pivot, the Append has 3 million rows of blank data! What am I doing wrong?
Screenshot of the connections below
You've not defined the data in the sheets as a table and it's bringing in all the blank rows from 31 sheets?
Thanks.. figured it out.. the headers need to match in the 31 sheets!
@Chalfie started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Question for the ninjas here...
I have 31 excel sheets linked in Power Query where I have created an Append with all the data in it. I can view the successful Append in Power Query editor.
When I open Power Pivot, the Append has 3 million rows of blank data!
What am I doing wrong?
Screenshot of the connections below