Forum Discussion

dont_show's avatar
dont_show
Regular Visitor
2 years ago
Solved

Load data once and remove all connections

I am loading 200-300K records from a legacy syste. As that data will never change I don't need to refresh it or add another connection.   How can I completly disconnect the source and just retain t...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi dont_show 
    You can uncheck the option of refresh from PQ

    but if this table merges with other tables in the model it will try to refresh this table too after publishing on the service. 
    In this case, you can just use CSV / Excel as a data source.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, dont_show 

 

Power BI is designed with the idea of maintaining the integrity and originality of the data source, so it does not provide the ability to disconnect the data source directly. You can disconnect indirectly by closing the relevant software, but this is temporary and the connection will be automatically restored when you use it again. You can only export all the data in the legacy syste if you can. You can submit an idea for here and the product team will take note of such a need.

 

Related Link: New tab (powerbi.com)

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum