Forum Discussion
will Data Refresh also updates my merged table
Hi folks,
I have two tables A and B in my Report. Iam merging this two tables as new table using Inner Join. My query is when i Refresh my data in Power BI, will my Merged Table also gets updated data along with Table A and B.
Please let me know the answer for this.
TIA
5 Replies
- Greg_DecklerCommunity Champion
techvidya Yes, whether your merge is a Merge query or NATURALINNERJOIN, it will be refreshed.
- amitchandakSuper User
techvidya , ideally steps of power query/edit query should repeat after each data load.
I am hoping you are talking of - https://radacad.com/append-vs-merge-in-power-bi-and-power-query
- RG007Helper II
if you will be using only merged table, not the individual table, then you can disable load on them.
it will help in improving performance.
- AnonymousNot applicable
Hi techvidya ,
As soon as the following options are checked for merged table (Checked by default), yes it will.
Best Regards,
Jay
- AnonymousNot applicable
I have a merged table which does not update after refresh, only the individual source tables do update. "Include in report refresh" is ticked, but merged table does not get updated.
Can anyone support? Thank you.