Our applications are designed to accommodate non-working days, such as holidays and weekends. By configuring non-working days in the connector app, you can conveniently filter your data in Power BI to exclude non-working days. To get started with setting up non-working days, please follow the instructions provided below.
Prerequisite: Please make sure you have installed the Power BI Insights Connector App.
In Dynamics 365 Business Central open the Power BI Insights Connector App.
1. Select Base Calendar Code. Selected calendar code will determine which days are considered non-working days.
2. Select Actions > Calculate Nonworking Days.
This action will create or re-create the non-working days setup based on the calendar code you have selected.
3. Select Related > Nonworking Days.
This page displays a list of holidays and non-working days, and you can add additional non-working days by editing it.
After completing the setup process, please proceed to initiate a manual data refresh in your Power BI Workspace.
In Power BI, you can utilize the 'Is Working Day' filter to exclude non-working days from your data.