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.

2015-10-28

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.

2015-10-05

2,714 reads

Blogs

New Blog post- Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration

By

  Check out my new blog post-Best practices for migrating Microsoft SQL Server databases to...

Data Saturday #8–Southwest US

By

I am very excited to announce that I will be speaking for Data Saturday...

Data Weekender v3.1

By

I am super excited about this new version of Data Weekender, coming up on...

Read the latest Blogs

Forums

Cannot attach databases in folder after power outage

By cphite

We had a power outage on one of our hosts, and it unfortunately caused...

Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation

By Mohsin_A_Khan

Comments posted to this topic are about the item Understanding CRUD Operations on Tables...

The Number Subquery

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Number Subquery

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers