Forum Discussion

LaMachina1993's avatar
LaMachina1993
Regular Visitor
9 months ago
Solved

Incremental Refresh with reference and merged table for SharePoint-Files

Hi, I have a question about my problem with incremental refresh in Power BI Service. I load XML files from a SharePoint folder, which I then prepare in a base table (Table A). I then have several ta...
Need Help
  • LaMachina1993's avatar
    LaMachina1993
    8 months ago

    I found the problem. Due to a pivotization in my query, an error message appeared because a column name no longer matched. I changed the code so that the column names are enforced before pivoting and are statically defined if one of these values is missing in my data source and an error message is generated as a result. It is also important that RangeStart and RangeEnd are applied to the date filter in reference tables and grouped tables and that incremental updating is set up there. Setting this up for the base table alone is not enough!

LaMachina1993's avatar
LaMachina1993
Regular Visitor
8 months ago

I found the problem. Due to a pivotization in my query, an error message appeared because a column name no longer matched. I changed the code so that the column names are enforced before pivoting and are statically defined if one of these values is missing in my data source and an error message is generated as a result. It is also important that RangeStart and RangeEnd are applied to the date filter in reference tables and grouped tables and that incremental updating is set up there. Setting this up for the base table alone is not enough!