THE NUNEZERP NOTEBOOK

BI

Search articles

YearMonth

4 articles in BI

Business Central Applied technology BI API

How to connect Power BI directly to Business Central without using Power Query

Power BI has a standard connector that provides direct access to Business Central data, without having to manually create queries in Power Query or configure web services.

10 Nov 2026Read article

Applied technology BI AI

Analyze a Power BI report with AI without sharing the data

Traditionally, BI specialists have almost always needed real data to analyze a result, especially when dealing with complex calculations. However, to analyze how a data model or a visual on a dashboard works, AI does not need the data, just the underlying structure.

28 Oct 2026Read article

Business Central Applied technology BI API

How to connect Excel to Business Central using Client ID and Client Secret

Connect Excel to Business Central from Power Query using a Microsoft Entra application, without relying on a user account.

7 Oct 2026Read article

Business Central Applied technology BI

How to connect Excel to Business Central using a user account

A fairly straightforward way to do this is to connect directly from Excel through Power Query and authenticate using a Business Central user account.

5 Oct 2026Read article