My post earlier this year on enabling query folding when using SQL queries as a data source in Power Query provoked a lot of interest. This post adds one more useful detail: how to preserve the ...

A few months ago a new option was added to the Sql.Database and Sql.Databases functions in Power Query in Power BI and Excel which allows Power Query queries that combine data from different SQL ...

Microsoft introduced Power Pivot as a separate add-on provided by Microsoft’s SQL Server 2008 R2, which was released in 2010. Back then, it was named “PowerPivot” with no space. In 2013 it was renamed ...

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 ...

For Power Query to properly transform the data, you must correctly identify and specify the delimiter. For example, in our case, a less than sign (<) separates the names and the email addresses.