Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@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
@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
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |