Forum Discussion
Trouble connecting to data source (Excel file, not in table format)
Community ChampionHi MillyF ,
Not sure what you mean by "I have tried to select many columns to the right of my data and delete them (maybe there are additional columns that "contain data"?)"
And what do you mean that it cannot connect?
I do know that Power Query does better with fewer columns. Is it possible to divide the data onto different tabs? Also I might try to copy everything to a new workbook including the formulas in case that is the issue.
In any case ImkeF is a whiz with Power Query, maybe she can help!
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
I have been able to connect to the data source but I am still running into an issue where data under each header is not populating as soon as I close Power Query Editor.
I see data in the Power Query Editor, but it is not populating as soon as I close it.