Integration of external data

Join all data sources (Microsoft Dynamics + any other) across your organization into BI4Dynamics Data Warehouse. Have full control of external data quality and save cost by engaging your internal resources.

Option 1:

The feature of using a Direct Query for Azure Analysis Services and Power BI Datasets existed for almost a year, however, from October 2021 it gained various improvements.

BI4Dynamics traditionally copies data from Microsoft Database to the BI4Dynamics Data Warehouse where the data transformation happens. The Azure Analysis Services is used as a business layer to display this information for Power BI.

When the connection is changed from Live to Direct Query, the BI4Dynamics model is copied to a local Power BI file. On the direct query Power BI file, we can extend the model with any other source.

You can as well select a couple of tables from the BI4Dynamics Analytical model that consists out of 12 application areas, 47 transactional tables, 133-dimensional tables, and 2100 measures.

Watch the video to see how this model operates, based on a real scenario with real Power BI Reports, hence, understand and estimate the promising ROI you are able to get by using this feature.

Option 2:

Part 1: Get data from external sources into BI4Dynamics data warehouse database (80% of effort).

Create an SSIS package with SQL Server Data tools (free Microsoft) with simple Import-Export Wizard to cover almost all import-export scenarios from any data source into BI4Dynamics SQL database.

Part 2: Create new BI structures with the Data Warehouse Automation Wizard (20% of effort).

Creating transactional tables (facts), lookup tables (dimensions) and cubes with our Data Warehouse Automation Wizard is straightforward. Click to see how: D365 (AX) or BC (NAV.

Watch videos to see how to prepare and include SSIS packages to BI4Dynamics or download the document