Forum Discussion

_power_bi's avatar
_power_bi
Helper I
1 year ago
Solved

Incremental Refresh not working in Service

We have a Fabric datalake setup with a table there as a source in Power BI.  We also have an on-prem SQL Server as a source. I used the RangeStart and RangeEnd parameters  for incremental refresh on ...
  • _power_bi's avatar
    1 year ago

    I removed incremental refresh (right clicked on the table in the pbix and turned it off) and then saved a new pbix and published to my workspace.  It took about 20 minutes and refreshed. So, the issue is with the incremental refresh from a Fabric Lakehouse table. 

     

    I noticed that when turning on incremental refresh in desktop, there is warning that it is unable to confirm if the query can be folded. (The query was a select * but it was a native query).  I removed that and simply connected to the table then filtered to the paramaters as before.  If you right click on the applied step (not the source step but any steps after), it should say 'view native query'.  If it doesn't allow you to click that, then it probably is not "foldable".  Again, I am not sure why the error was credential related. That threw me off.