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?
Any ideas?
Asked
Active
Viewed 68 times
-1
FeeFiFoFum
- 1,719
- 1
- 11
- 18
-
You can refresh individual queries in PowerBI Desktop, right click on table name -> refresh data. – user5226582 Oct 11 '16 at 13:43
-
But is it possible to do this with automatic refresh on the PowerBI Service? I'm going to be hosting my reports in PowerBI Embedded on Azure. – FeeFiFoFum Oct 11 '16 at 22:05
-
1Thanks. You should always post this kind of information in the question, otherwise it's vague. – user5226582 Oct 14 '16 at 08:16
1 Answers
0
(about PowerBI Embedded):
"Currently direct query is all we support in terms of refresh. Cached refresh support is certainly on our backlog as well as pushing data. As one of the previous posts suggests, you could update the file manually and re-upload it as a workaround for now.", Power BI Team
DirectQuery cannot be combined with other data sources, and it always fetches data from the source (about directquery),
On a side note, you probably should aggregate your 50M rows, if that's possible.
Alternatively, if self hosting PowerBI Server is an option, you could look into moving your model to a Tabular SSAS Database, which supports partitioning.
user5226582
- 1,946
- 1
- 22
- 37