Solved: Re: Temp disable data source?

sanderson82 · ‎09-18-2019

Hi

I have a report which connects to 3 plant PC's relating to production, sources are added to a gateway and set to refresh on a schedule.

For an extended period of time (few months) one of the plants is going to be offline. This is obviously having an impact on the report as the scheduled refresh is now failing.

Is it possible to temporarily disable tables/sources in a report? Ideally I don't want to have to recreate the whole report excluding the offline plant

Regards

Steven

Anonymous · ‎09-18-2019

@sanderson82 Under "Edit Queries" in the PBIX file you can right click on the queries coming from the plant and click the "Enable Load" checkmark to disable the load of that query. That seems to ignore the datasource, and might work. It is likely that the visuals that use only that data would be broken during the downtime, but I don't believe it would break the entire report or cause it to be unable to refresh.

View solution in original post

Anonymous · ‎09-18-2019

@sanderson82 Under "Edit Queries" in the PBIX file you can right click on the queries coming from the plant and click the "Enable Load" checkmark to disable the load of that query. That seems to ignore the datasource, and might work. It is likely that the visuals that use only that data would be broken during the downtime, but I don't believe it would break the entire report or cause it to be unable to refresh.