Forum Discussion
Advocate IIData Refreshes and DirectQuery for Power BI datasets and Azure Analysis Services
Ahhh... open Optimize Performance. Scheduled Refresh has moved for DQ models in some tenants. See discussion here.
Community ChampionYou don't. It is a live connection. When the source dataset refreshes, when you look at the report connected to it, it is up to date. A report connected to a dataset doesn't have its own dataset. It is using the dataset you are connected to. You could think of it as a normal report. You have the report and the dataset. The dataset needs to refresh. The "report" part does not. It is just up to date.
For models with the new composite model (Direct query over AAS/PowerBI) there is a dataset published, but it is a passthrough, or DirectQuery, so it too does not need to refresh.
Advocate IIThanks but I'm more so referring to an additional table that is added to the report. So, the report is feeding from a master datset yet we've also added an additional table from an outside source. This table resides in an import mode and sits alongside the direct query tables from the master dataset. The question is how does one update the imported table and data content?
- edhans
Are you sure that other table is in import mode? It should allow refresh for any tables native/stored in the model.
- TSHECKEL
Yes, it's residing in an import mode. It doesn't appear that there's a way to schedule a data refresh for this table within the service.
- edhans
Ahhh... open Optimize Performance. Scheduled Refresh has moved for DQ models in some tenants. See discussion here.