Forum Discussion

vickyd's avatar
vickyd
Icon for Helper V rankHelper V
8 years ago

Make PBIRS forget a connection after load

I have imported some data from an excel file into the model. I don't want it to refresh ever again so I have disabled "Include report in refresh" and "Enable Load"options.    However, the data sour...
Data Source
load
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

I do not know of a way to do that. I was thinking maybe File | Options and settings | Data source settings but that does not allow you to delete the connection.

chrisfin's avatar
chrisfin
Icon for Power BI Team rankPower BI Team
8 years ago

While you can't delete the connection per se, it won't get updated data unless you set a refresh schedule for your report, so you won't have the data updated.  That should give you what you need for your scenario, correct?  Let us know - thanks!