Forum Discussion
How to Break Link Excel File
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.
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!!
3 Replies
- AnonymousNot applicable
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.
- NaveenGandhiMemorable Member
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!!
- NaveenGandhiMemorable Member
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!!