will Data Refresh also updates my merged table

[techvidya]

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

[Anonymous]

Hi @techvidya ,

As soon as the following options are checked for merged table (Checked by default), yes it will.

Best Regards,

Jay

[Anonymous]

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.

[amitchandak]

@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

[RG007]

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.

[Greg_Deckler]

@techvidya  Yes, whether your merge is a Merge query or NATURALINNERJOIN, it will be refreshed.