Forum Discussion
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 source still shows up when I deploy to a Production Report Server. The file is not accessible from the Production server.
I don't necessarily want the refresh to work. I want to know how can I import something one time and let the model forget about the connection?
2 Replies
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.
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!
