How to Break Link Excel File

[dashmarley11]

I have an Excel file that I loaded into PowerBI but I need to break the link so that the file is never included in the refresh schedule and always stays static.

[NaveenGandhi]

Untick the include in report refresh, It won't be included in report refresh.

 If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

[dashmarley11]

@NaveenGandhi  The file is way too big (3,000 Cell Limit) and would take 10+ Append Queries and so I was hoping there was an easier way.

[NaveenGandhi · Accepted solution]

Hi

Why not just paste the data directly by using Enter data.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!