Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    Not 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.

  • NaveenGandhi's avatar
    NaveenGandhi
    Memorable 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!!

  • NaveenGandhi's avatar
    NaveenGandhi
    Memorable 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!!