topic Re: Make PBIRS forget a connection after load in Report Server

Make PBIRS forget a connection after load

vickyd — Sun, 29 Apr 2018 14:30:59 GMT

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?

Re: Make PBIRS forget a connection after load

Greg_Deckler — Sun, 29 Apr 2018 15:09:42 GMT

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.

Re: Make PBIRS forget a connection after load

chrisfin — Wed, 02 May 2018 00:24:04 GMT

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!