Forum Discussion

zenisekd's avatar
zenisekd
Super User
1 year ago
Solved

Data update in report combining Direct Query and OneLake Data Hub (Power BI Semantic Model)

Hi,  I am facing a difficulty with updating a report, which uses onelake datahub and direct query.  I created a report R2, which uses OneLake Data Hub(Power BI semantic model) S1 connector and ...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

     

    I would have expected, that a change to S1 after publishing would immediately take effect on the R2 online

     

    That is only true for data, and for varying interpretations of "immediately".

     

    Meta data changes need to be propagated.

zenisekd's avatar
zenisekd
Super User
1 year ago

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.

lbendlin's avatar
lbendlin
Super User
1 year ago

Those tools are for meta data manipulation. They are not data extraction tools.

 

What you are referring to are the PBIX download limitations. While that list is long, it has gotten shorter recently.

 

HOWEVER.  Incremental Refresh is based on having multiple partitions per table.  Power BI Desktop has no concept of that. So even if you were allowed to download a PBIX with incremental refresh data sources you still could not open it in Power BI Desktop.