Jean-Pierre Riehl on 17 Aug 2017 15:02:16
Ability to exclude a table from Data Refresh (scheduled, manual, API, etc.) in the Service.
In PBI Desktop, we have an option "Include in report refresh" we can disable for a table. But it won't affect PBI Service.
- Comments (83)
- Merged Idea (2)
RE: Exclude a table from refresh in Power BI Service
It has taken me 3 days to figure out that this is what the problem has been for weeks with scheduled refreshes in the Power BI service that fail trying to refresh a table I've disabled load for. Why in the name of all that's holy would the service query a table that you've marked not to query? I agree with the comment that this is a bug, rather than an enhancement. I've needed to completely delete queries that I disabled in Desktop because they were failing in the service.
RE: Exclude a table from refresh in Power BI Service
Any update on this?
I have tables coming from both: Business Central (dynamic data that need to be refreshed 8 times a day) & Azure SQL database (fix data that needs to be refreshed only once a week)
RE: Exclude a table from refresh in Power BI Service
This is a bug, not an enhancement. It needs to be prioritized and fixed as a bug (i.e. asap)
RE: Exclude a table from refresh in Power BI Service
I support the need to exclude tables from refresh in Service.
I have a combination of Onedrive Excel files and Oracle tables. I used Web connector as well as DirectQuery Oracle connector. I will exclude the Oracle tables from refreshing in Desktop, but this is not possible in Service. And the Scheduled Refresh fails.
RE: Exclude a table from refresh in Power BI Service
Please fix this issue so that I can archive tables with "As of" dates.
RE: Exclude a table from refresh in Power BI Service
Big oversight, needs to be fixed on PowerBI.com Portal to match the Desktop option! Have raised a case (likely not the only one) and they've acknowledged, but it's not on their ETA timeline yet, so keep voting.
PowerBI.com customers should be able to have static tables with refresh disabled to avoid setting up unnecessary Gateway datasources to their PC which will eventually FAIL when PC or server switched off! Pasting into "Enter Data" tables is not always a solution as they only allow 3,000 cells.
Its perhaps good to encourage permanently refreshable Azure SQL DBs instead of static or semi-static tables, but better to fix this.
RE: Exclude a table from refresh in Power BI Service
Please add this feature, we really need to only query the data that we need
RE: Exclude a table from refresh in Power BI Service
Can't believe this bug is real
RE: Exclude a table from refresh in Power BI Service
As many others here said, this is very bad design. You basically disable refresh and it still wants to refresh the data source in Service. Just please fix it.
RE: Exclude a table from refresh in Power BI Service
We need this! I am importing the same postcodes every time!