Some of my data tables are huge and the data never changes (50 million rows+). And some is quite small and needs regular refreshing. How do I handle this in PowerBI?
This feature became available a few months ago in Power BI service. Wasn't sure if you kept up to date with it.
We are a new contributor to the Power BI User Group online community. So, catching up a bit.
Can you assist me in finding how can I prevent a table/query's refresh on Power BI service?
The option in query editor worked perfectly when you are deailing with refreshes in Power BI desktop, however, table/query gets included once published to online service.
I'm checking with my team, as this was previously documented to have been available in Power BI service as well. Unfortunately, I too cannot get it to function at the moment. I'll keep you posted.
@ashishkabra09 this has been available for Premium. As of February it was GA for Pro - https://powerbi.microsoft.com/en-us/blog/incremental-refresh-is-generally-available/
@Anonymous If you go to query editor ->right click your table -> Properties -> Untick 'Include in report refresh', that will stop that table from being refreshed each time you hit refresh on power bi desktop. However that functionality is currently only available in bi desktop and you should vote for extending that to power bi service here.
@Anonymous Assuming you are importing the data (that must take awhile), there is no way to selectively choose which tables/Entities to schedule a refresh (this assumes the Service because you can't schedule a refresh in the Desktop. You can right click on the individual tables/entities and refresh them individually, but once you publish to the Service the whole data set is refreshed. Is Direct Query or Live Connection a possibility?