News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Adding dates for Power...

Finance | Project Operations, Human Resources, ...

Answered

Adding dates for Power BI Date Dimension for D365FO

(0) Share

Report

Report

Posted on by M.Hammam

29

Hello all,

a lot of reports/charts that are related to Power BI in Dynamics 365 Finance and Operations do not work properly because of missing dates in Date_ dimension related table

Checking table BIDATEDIMENSIONVALUE in AxDW database showed it is filled with dates until 31-Dec-2022.

How to fill the date dimension table BIDATEDIMENSIONVALUE with other dates until 31-Dec-2023?

Thanks a lot in advance,

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Dimitris Kod 22 on at

Like (2)

Report
Adding dates for Power BI Date Dimension for D365FO

Hi,

You have to go Organization Administration\Setup\Calendars\Date Dimension

Place the correct date interval and afterwards close the form. Open the form from the menu once more and the dates will be populated

Organization administration

Setup

Calendars

Date dimensions

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans