Forum Discussion
Refreshing an Appended Table
Hello,
Data Entry Set Up:
Power App connected to an Excel Online workbook. Data then feeds into Power BI with each sheet being a seperate table.
Problem:
I have appended multiple tables (11 tables) together in Power Query in order to give me a table that summarises the following:
| SessionDate | Name | SessionComplete | _PowerAppsID_ | SessionType | SessionCount |
However, when new data gets inputted into the seperate tables it then doesn't end up in the append table. Is there a solution to this?
Thanks in advance.
Anonymous , When you import an excel, just check if shows all worksheets on a single step. If yes then remove all steps post that, and use binary expand(and merge) near to column name
2 Replies
Anonymous , When you import an excel, just check if shows all worksheets on a single step. If yes then remove all steps post that, and use binary expand(and merge) near to column name
Thank you amitchandak !