Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everybody,
I'm trying to use Power query and Excel as a kind of Database, maybe it's not the good solution, but I would like your advice.
As my english isn't the best, I made a small drauwn to explain :
I would like to be able to use a result query as the main query the next month, so I can recursively add data each month : The Yellow arrow is my problem I guess !
Thank you for your help
Pierre
PS unable to use the drag and drop function to add a xlsx file ... sorry for that
Solved! Go to Solution.
Hello,
I found a easy way to answer my problem :
- Create a "connexion only" on first Table (AAA)
- Create a connexion on the second Table (BBB), make your modification (Append ...), Save and Publish in the Workbook
- At this step, you should have a new Table named BBB_2, for example
- Delete the entire Table BBB
- Rename the Table BBB_2 => BBB
- That's all folks
It works for me, thank you for your help everybody
@Anonymous could you use a blank query and just append each month in?
Fake Data tables
Start with blank query then append each month/table and it'll keep growing
let
Source = #table(null,{}),
#"Appended Query" = Table.Combine({Source, #"Jan Data", #"Feb Data"})
in
#"Appended Query"
Think that gives the result you are after?
Thanks,
Hi,
Is it more clear with this snapshot ?
The "ID" column is the mail
Thanks
Hello,
I found a easy way to answer my problem :
- Create a "connexion only" on first Table (AAA)
- Create a connexion on the second Table (BBB), make your modification (Append ...), Save and Publish in the Workbook
- At this step, you should have a new Table named BBB_2, for example
- Delete the entire Table BBB
- Rename the Table BBB_2 => BBB
- That's all folks
It works for me, thank you for your help everybody
At least, her is a snap of my tables :
@Anonymous If there is no way to tell the month from the data then the file should have some indication, otherwise how will you define logic?
I have to precise : there isn't any kind of calculation, it's just some tables like "Name, Surname, Mail, ..."
I try to add a link to my file,
Regards
@Anonymous It is doable with List.Accumulate, you can post the data on google drive and create a shareable link.