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

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
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

  • dont_show's avatar
    dont_show
    Regular Visitor
    2 years ago

    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.