Forum Discussion

MangeshVC's avatar
MangeshVC
Frequent Visitor
2 years ago
Solved

Values gets doubled for specific dates while using Power BI Semantic Models

I have created a Report using SQL Server & uploaded to service. 

Then I used the dataset of the same to create another report by using Get Data --> Power BI Semantic Models Option.

I do observed very weird behaviour of new report. I have data from 01 Aug 2023 to till date. The output for the dates 01 Jan 2024, 01 Feb 2024, 01 Mar 2024 gets doubled. I thought the issue is with first day of month, so I checked for the same output on 1st of every month from Aug to Dec 2023. But for these dates, correct values are shown.

 

I am unable to figure out the issue. Please help to get through the same.

  • You are using Incremental Refresh and have misconfigured the RangeStart and RangeEnd filters.  One of them must be inclusive, the other must be exclusive. 

2 Replies

  • You are using Incremental Refresh and have misconfigured the RangeStart and RangeEnd filters.  One of them must be inclusive, the other must be exclusive.