A practical guide for data engineers, BI developers, and anyone building on Azure Synapse. Your Power BI report takes 40 seconds to load. Users are raising tickets. You open your Synapse workspace and ...

Perhaps you created a dataflow but then had difficulty getting data from it (either by using Power Query in Power BI Desktop or from other dataflows). This article explains some of the most common ...

Kusto Workbench is built for the tight loop of writing queries, running them, inspecting results, and iterating quickly; without forcing you to abandon existing .kql / .csl files. It uses the official ...

When developing a Power BI semantic model, the default storage format is import mode. For good reasons: It supports a wide set of sources, is very fast and supports all Power Query and DAX operations.

A few months ago I blogged about the new limits available for the Maximum Connections Per Data Source property in Premium and why the number of connections that a DirectQuery semantic model can open ...

If you’re using DirectQuery mode for one or more tables in your Power BI dataset, the chances are that you will want to see the SQL (or whatever query language your DirectQuery data source uses) that ...