Power BI

External Article

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.

2015-10-28

2,633 reads

External Article

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.

2015-10-05

2,714 reads

Blogs

How to Learn SQL Without Quitting Your Day Job

By

Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...

Friday Flyway Tips: Chaining Commands for State-based Deployments

By

One of the cool things I’ve seen with the new Flyway CLI is that...

A New Word: Querinous

By

querinous – adj. longing for a sense of certainty in a relationship; wishing there...

Read the latest Blogs

Forums

How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server

By Noman072

Comments posted to this topic are about the item How to Avoid Incorrect Results...

The AG Secondary Logs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AG Secondary Logs

Simple(r) Coffee

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Simple(r) Coffee

Visit the forum

Question of the Day

The AG Secondary Logs

What happens when an AG secondary receives a log record from the primary?

See possible answers