Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.