The Excel and SQL Server experts blog

Power BI dashboards and reports often pull data from a SQL Server database, but what happens when you need to update that data? For businesses, having Power BI write-back to SQL functionality is critical for staying agile. In this article, we’ll explore two methods for writing back to SQL, including the SQL Spreads Excel Add-In, …

Power BI makes it easy to visualize your data, but first, you need to connect it to SQL Server. This guide walks you through the process step -by -step. With SQL Spreads Excel Add-In, business users can bring in and update SQL Server data themselves — all from Excel — ensuring that your Power BI …

In an earlier article, we looked at how to create a dashboard based on some sales data.  The data source for that example was several tables in a SQL database.  In this article, we’re going to look in more detail at the data model we built in that Power BI example, and specifically the use …

In an earlier post, we introduced Power BI and looked at what makes a good dashboard.  In this article, we’re going to go through the steps for creating reports with Power BI, SQL, and Excel.   How Does Power BI Work? A Brief Overview Power BI is a Business Intelligence (BI) platform. With Power BI, …