Forum Discussion

zenisekd's avatar
zenisekd
Super User
4 years ago

Enable load/Include in report refresh - Bug or Feature?

Our customer migrated to SAP, but couldn't load all historical data, so we kept it in the data wareshouse. Therefore for BI reports I did some merging and appending (of SAP and DWH) and I was hoping,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI zenisekd,

'Include in report refresh' option will disable the refresh request so that the target data model table will keep current data without refresh.
'Enable load to report' option will affect the backend and front data model table transform. If you turn off it, this target query table will keep the preview snapshot of query table steps and its M query code did not process to generate the corresponding data mode tables.

In addition, scheduler refresh also works on the dataset instead of detailed data tables. If you want to accurately control the refresh of each table, you can take a look at the following blog to use TMSL(Tabular Model Scripting Language) to config the refresh.

Trigger a single table to refresh in the Power BI Service – Data – Marc (data-marc.com)

Regards,

Xiaoxin Sheng

zenisekd's avatar
zenisekd
Super User
4 years ago

When I disable 'Include in report refresh' for a table from my DWH (with historical data) and then append it with my SAP database (current data table), and I use a refresh button, it refreshes both DWH and SAP data in the appended table. And it pulls data from my DWH. This makes no sence. 

Since we are not using a premium account, the XMLA endpoint solution is not suitable for us plus I am really not sure if that would be working in case of an appended table again. 

So far the only solution I found is to load both tables separately (DWH and SAP table) and then use UNION to create the appended table in DAX. This is however not the most effective solution... 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI zenisekd,

    According to your description, it sounds like you applied the merge the query tables that you set different options?
    If that is the case, I think these merge/combine functions will force active the refresh request to the parameter tables used in this operation.

    I'd like to suggest you do these operations on the database(mapping historical table to your database and append to the fact table records)or data mode side which has been initialization the table records so that the following operation will not trigger the underlying data sources refresh.

    In addition, you can also submit an idea for improving the 'refresh' options in the query editor.

    Regards,

    Xiaoxin Sheng