Forum Discussion

KJChin's avatar
KJChin
Frequent Visitor
1 month ago
Solved

Power BI Refresh Error In Workspace

I have applied incremental refresh to two tables in Power BI and published to workspace. When refreshed, it showed error as this: Data source errorExpression.Error: There weren't enough elements in...
Need Help
  • Gabry's avatar
    Gabry
    1 month ago

    Hey buddy,

    try to change the last step, set fixed columns names

     

    #"Expanded Table Column2" = Table.ExpandTableColumn(#"Removed Other Columns2", "Transform File (7)", {"Column1", "Column2", "Column3", /* ... list all columns names here ... */})

GilbertQ's avatar
GilbertQ
Super User
1 month ago

Hi KJChin 

 

What I typically recommend for people to do is to make sure as soon as you can in your steps you transform the column which are going to use for incremental refresh to data and then apply the incremental refresh range start and range end. There and then meaning it is applied within the first two steps. That should typically resolve any other issues that you have.