search

sql-bi / DaxDateTemplate

Power BI template to create a Date table in DAX
MIT License
265 stars 76 forks source link

Weekly DAX Date Template - Date update issue #77

Open rogasf opened 4 months ago

rogasf commented 4 months ago

Hello!

I was working with the Weekly Dax Date Template, initially with data from the financial years of 2023 and 2024. However, when I attempted to include data from previous financial years (2020-2022), I was getting errors to load my data model saying that unique identifiers were being duplicated - probably associated with my date table. I tried to refresh my date table preview within Bravo to cover the updated years, however the same issue happened. Do you know if there's any step required to ensure my date template adapts to changes in dates from my data source?

marcosqlbi commented 4 months ago

It is strange that the problem is related to the Date table created by Bravo. Can you try to copy the PBIX file and remove all the tables but Date to see if the problem is there?