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.
If I create a calendar table in Power BI with function = Calendar( "2020/01/01" , Today() ) , when is the table going to be refreshed? If i dont hit the refresh data button for 5 days (My model is mixed - lookup/data dicitionary tables are import while critical tables with data are direct query), I will only see Calendar table for Today - 5 days or will i see the new rows automatically added without refreshing?
Solved! Go to Solution.
Hi @LazyUser
You might refer to the document for what's refreshed in power bi service:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
For Composite models, based on my test, We can configure the scheduled refresh on it, the cache of titles will refresh after refresh complete, we can configure maxium 8 times on shared capacity or use on-demand refresh.
furthermore, the advantages and disadvantages associated with Import and DirectQuery, depending on how each table is configured. But it may reduce the size of dataset and duration time of refresh because some table use direct query instead of Import. Please refer to this document about the Composite models: https://docs.microsoft.com/en-us/power-bi/service-dataset-modes-understand#composite-mode
Hi @LazyUser
You might refer to the document for what's refreshed in power bi service:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
For Composite models, based on my test, We can configure the scheduled refresh on it, the cache of titles will refresh after refresh complete, we can configure maxium 8 times on shared capacity or use on-demand refresh.
furthermore, the advantages and disadvantages associated with Import and DirectQuery, depending on how each table is configured. But it may reduce the size of dataset and duration time of refresh because some table use direct query instead of Import. Please refer to this document about the Composite models: https://docs.microsoft.com/en-us/power-bi/service-dataset-modes-understand#composite-mode
@LazyUser , it should refresh automatically. is it not ?
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.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |