What a semantic layer is, who really needs one, how dbt, Cube, Looker, AtScale and the warehouses differ, and a plain-SQL version a small team can run from its IDE.
Tagged
Power BI
Every article tagged Power BI, newest first.
A read-only MCP server, built in one evening, let the AI agent see the Postgres behind a Power BI model. A 2,200-line query went from five minutes to 15 seconds.
Power BI for reading, Excel for working, one agreed default view behind both — a DAX query stored next to the SQL, in the same table and the same git repo.
Your CEO won't open the dashboard. Fabric can query the semantic model from a notebook and email a formatted HTML table straight to their phone.
A top-down waterfall that traces a mining fleet's 24/7 time down through every idle category — a plain stacked bar chart and three DAX measures.
Stop copy-pasting SQL between your IDE and Power BI. Keep the query in a Postgres table and let Power Query pull it in on every refresh.