Power BI

Using Power BI in a Hybrid Environment

  • Article

This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores.


2,633 reads

Power Query Formula Language in Power BI Desktop

  • Article

The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from scratch. In this article, Rob Sheldon demonstrates how to use it in Power BI Desktop to extract data from its source, filter rows, specify the columns, clean the data, and create visualisations.


2,714 reads


Reflection on Talking at SQLSaturday Charlotte About Mental Health


On December 7, I did a session on mental illness and mental health problems...

A guide to acronyms, abbreviations, and other technical terms


Here’s a list of some technical terms, acronyms, and abbreviations you may have heard,...

T-SQL Tuesday #121: Gifts received for this year


At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve...

Read the latest Blogs


Script Task - use DataTable for performance improvements?

By DinoRS

Hi SSC, I have this Script Task which will make quite a few reebars...

Probably Invalid Parameters Email Failure

By clarmatt73

We have a job which runs throughout the day which sends emails out if...

ssrs - VS 2019 - extra row - continued from previous page

By arkiboys

Hi, I have a table inside a rectangle - Table design-1.png. The rectangle has...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers