Forum Discussion

Archie2024's avatar
Archie2024
New Member
2 years ago
Solved

Getting error when trying to combine files from a folder

Hi, I am trying to combine two files from a folder. I came up with an error message. I'm not sure what I'm doing wrong. I am a novice at PQ, so any help is much appreciated.   For context, I conve...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Archie2024 ,

    -Add custom column, entered Excel.Workbook[Content]


    Please try this:

    Excel.Workbook([Content])[Data]{0}

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

  • Archie2024's avatar
    Archie2024
    2 years ago

    I really appreciate everyone's help! That worked! Thank you!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Archie2024 ,

-Add custom column, entered Excel.Workbook[Content]


Please try this:

Excel.Workbook([Content])[Data]{0}

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Archie2024's avatar
Archie2024
New Member
2 years ago

I really appreciate everyone's help! That worked! Thank you!