Forum Discussion
Single Visualization from Separate Tables
Hello All, We are working on creating a T&E Expenses Dashboard as an audit group where we can view/filter the expenses in a variety of ways, then drill down to the raw data to export to Excel. W...
Hi,
The video at this link should help - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks - YouTube.
That makes sense to simplify the input to the visual...If you're (@mahoneypat) able, I have a follow up question. I looked at the Microsoft User Docs for Appending (https://docs.microsoft.com/en-us/power-query/append-queries). It does not appear that I have the menu available that is shown in the document in order to append. Are there troubleshooting steps to add this?
Hi,
The video at this link should help - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks - YouTube.