Forum Discussion
Data update in report combining Direct Query and OneLake Data Hub (Power BI Semantic Model)
- 1 year ago
I would have expected, that a change to S1 after publishing would immediately take effect on the R2 onlineThat is only true for data, and for varying interpretations of "immediately".
Meta data changes need to be propagated.
So the only way to propagate the metadata change the desktop has to be refreshed? no other way to do it online from service?
Sort of. You also have ALM Toolkit and Tabular Editor that can push meta data changes.
- zenisekd1 year agoSuper User
Would you say that it is more comfortable than using the desktop report itself? anyway, thanks for the reply.
- lbendlin1 year agoSuper User
Not more comfortable, but less invasive. A prime example is a semantic model that includes an incremental refresh data source. When you make changes to that model in the Desktop and then publish, this will reset (ie destroy) all your incremental refresh partitions and will attempt to refill them. Not only is that wasteful, it may also time out.
So instead you can use ALM Toolkit to propagate only the meta data changes without killing the partition definitions.
- zenisekd1 year agoSuper User
Thank you. When you mention Incremental Refresh, is it possible to download via ALM toolkit or Tabular Editor the full report (that has incremental refresh) from the service? Some time ago I was discussing with somebody that it is annoying that you cannot download it even in the template format through regular channels.