Forum Discussion
Add an extra column from excel source
To be honest, I can't quite follow your steps, as these mention csv which is not applicable here.
Looking at your query code, it seems to me that the issue is with:
#"Power BI_Sheet" = #"Removed Other Columns"{[Item="Power BI",Kind="Sheet"]}[Data],as you have no "Power BI" sheet in the list of objects in your Excel workbook.
Edit: this also corresponds with your error message.
Shouldn't your code just be:
#"Power BI_Sheet" = #"Removed Other Columns"{[Item="Power BI 2018",Kind="Sheet"]}[Data],Then you should see your additional colum.
At #"Changed Type", you may want to adjust the column type of your new column, which is type any (ABC123) by default.
Just some screen shot from another topic:
To be honest, I can't quite follow your steps, as these mention csv which is not applicable here.
Looking at your query code, it seems to me that the issue is with:
#"Power BI_Sheet" = #"Removed Other Columns"{[Item="Power BI",Kind="Sheet"]}[Data],as you have no "Power BI" sheet in the list of objects in your Excel workbook.
Edit: this also corresponds with your error message.
Shouldn't your code just be:
#"Power BI_Sheet" = #"Removed Other Columns"{[Item="Power BI 2018",Kind="Sheet"]}[Data],Then you should see your additional colum.
At #"Changed Type", you may want to adjust the column type of your new column, which is type any (ABC123) by default.
Just some screen shot from another topic:
Hi Marcel,
I can only say, that i'm very impressed by your BI skills! It works perfectly.
Thank you for your time.
Kind regards Jonas