Using an on-premises data gateway to query an API using Python for your dashboards.

Going beyond field equality-based join conditions in Power Query.

In this article, we’ll see how to merge Business Central current & archived documents in Power BI to enable reporting on this data.

A guide to merging these special tables for a better report authoring & consuming experience.