Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

incremental refresh on table by reference

Hi, in my data model I pull a table from sql server and then after some transformations on power query I copy this table by reference. So I have two tables with the same data (only that one is set a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have a workaround that worked for my similar problem: In each query that references the main query, I set some dummy variables to RangeStart and RangeEnd. This tricked PowerBI into letting me enable incremental refresh on the referencing queries. Now the referencing queries are refreshed along with the main query in the dataset.

  • TrevorC's avatar
    TrevorC
    Advocate I
    2 years ago

    This is brilliant. THANK YOU!!

    I used the Advanced Editor in Power Query to edit the code of the query. This is the first three lines of the dependent/reference query:
    let
    vStart = DateTime.ToText(RangeStart,[Format="yyyy-MM-dd'T'HH:mm:ss'Z'", Culture="en-US"]),
    vEnd = DateTime.ToText(RangeEnd,[Format="yyyy-MM-dd'T'HH:mm:ss'Z'", Culture="en-US"]),

     

    One key piece is to configure Incremental Refresh ONLY on the dependent/reference table. I did NOT apply it to the source query.

     

    I was also getting an error saying "column does not exist in the rowset" in the service when trying to refresh. I resolved this by DELETING the file and republishing it.