Power bi service(Incremental refresh)

Hi Anonymous ,

It seems a modelling related issue in your case. As once you apply the RangeStart and RangeEnd Parameter the data gets filtered and the filtered data doesnt seems to have any issue. Due to this reason its getting refreshed in Power BI Desktop.

While in Power BI Service once you do a full/complete refresh the whole data gets refreshed and the required partitions are created in Power BI Service. In this case if there is any issue in the data wrt to cardinality the refresh will fail.

If its possible can you check if you have have duplicate value in the agency code column of the agengy master table . If yes then the cardinality needs to be changed accordingly.

Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified - RADACAD

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀