Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
Is it possible to use excel as backend for 2 or more connected tables.
If I make a change in one of the frontend tables, it will then change in the backend table?
(And therfore change in the others frontend table)
Regards
Tony
Solved! Go to Solution.
Hi @TonyHansson ,
In Power Query, we can use Merge or Append.
With above operations, we can combine with two or more tabls to get the 'third table' you mean.
And if you perform data operations in the original tables, your ‘third table’ will also be updated.
Merge Vs. Append Concepts in Power BI (Power Query... - Microsoft Power BI Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @TonyHansson ,
In Power Query, we can use Merge or Append.
With above operations, we can combine with two or more tabls to get the 'third table' you mean.
And if you perform data operations in the original tables, your ‘third table’ will also be updated.
Merge Vs. Append Concepts in Power BI (Power Query... - Microsoft Power BI Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @TonyHansson
The second part of your question is not clear to me. But yes we can use excel for 2 or more tables.
Can you possible explain it briefly what exactly you are looking for?
I want to work as a database
I want 2 tables to be the frontend connected to a 3rd table (as backend)
If I change a value in one of the frontend, it will be saved in the 3rd table (Backend), and
then also availble in the other frontend.
Regards
Tony
Hi @TonyHansson
Yes, that can work. As suggested by Stephen you can use Append or merge in Power query. So whenever a change is flown into Table 1 or 2, it will be shown in table 3.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.