Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
dont_show
New Member

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 the data in the model?

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @dont_show 
You can uncheck the option of refresh from PQ

Ritaf1983_0-1704680068966.png

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

3 REPLIES 3
v-yaningy-msft
Community Support
Community Support

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

Ritaf1983
Super User
Super User

Hi @dont_show 
You can uncheck the option of refresh from PQ

Ritaf1983_0-1704680068966.png

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Thanks for that. When I add as an excel file I still end up with a conection in the PowerBI service (portal). Due to current restrictions I can only have one data source connection for the dataset.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.