Forum Discussion
Import excel from file - many column's name changed
Dear All!
I need your expertise on the following.
I am importing several excel tables from a file.
From out of the blue 2 coulmns name got changed. Now the import runs to error.
I have found several solutions for that issue but only when your are connected to a single table.
But I am missing the solution for "importing from file".
Do you have any suggestions?
Thank you
BR,
S.
Maybe List.Zip can help with hardcoded list of desired column names.
e.g.
3 Replies
- Jakinta
Solution Sage
Maybe List.Zip can help with hardcoded list of desired column names.
e.g.
- edhans
Community Champion
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables. - AnonymousNot applicable
That might help. Will try it out.
Thank you