Register Log in

Power Query Formula Language in Power BI Desktop

Articles tagged Reporting Services

Power Query Formula Language in Power BI Desktop

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....

19 min read

Working with SQL Server data in Power BI Desktop

What's the best way of providing self-service business intelligence (BI) to data that is held in on-premise SQL Server? Not, it seems, Power BI 2.0...

24 min read

The Evolution of SQL Server BI

It is sometimes hard to keep up with Microsoft's direction in Business Intelligence. Over the years, we've been presented with so many ways of aggregating,...

14 min read

Using R to Explore Data by Analysis – for SQL Professionals

What's the best way for a SQL programmer to learn about R? It's probably by trying out various experiments with an interesting set of data,...

17 min read

Making Data Analytics Simpler: SQL Server and R

R and SQL Server are a match made in heaven. You don't need anything special to get started beyond the basic instructions. Once you have...

13 min read

Mobile BI with SQL Server Reporting Services

For users to get the information they need from mobile reports, we frequently have to tailor the way we design those reports to the characteristics...

30 min read

SQL Server Reporting Services Basics: Deploying Reports

Having designed and tested our reports, it's time to deploy them to the Report Server, so that our users can access them. Kathi Kellenberger demonstrates...

20 min read

SQL Server Reporting Services Basics: The Visual Controls

The challenge of report development is to present complex data in a simple, visually compelling way. The goal is to make it as quick and...

17 min read

SQL Server Reporting Services Basics: Customizing SSRS Reports

While the Reporting Wizard and basic report tables will do for prototyping, very soon we'll want to add some finesse to our reports, and allow...

23 min read

SQL Server Reporting Services Basics: Building SSRS Reports

SQL Server Reporting Services is one of the most popular components of SQL Server, but it has always been surprisingly difficult to get from one...

27 min read

SQL Server Reporting Services Advanced Charting

SQL Server Reporting Services (SSRS) has evolved over the years to incorporate many new data visualization capabilities. In this article, Scott Murray illustrates how DBAs...

21 min read

SSRS Reports as a Data Source in Excel 2013

DBAs are expected to know how to administer the technologies that are available with and peripheral to SQL Server. To properly administer them, it certainly...

11 min read

Using DAX to create SSRS reports: The Basics

You can use DAX to create reports from a tabular database in SQL Server Reporting Services. To do so requires a few workarounds. Rob Sheldon...

15 min read

Using Microsoft Excel to Retrieve SSAS Tabular Data

Although it is well-known how to create a tabular database in PowerPivot, it is less obvious that there are several useful options for retrieving SSAS...

19 min read

Using DAX to retrieve tabular data

Data Analysis Expressions (DAX), originally the formula language for PowerPivot workbooks, can also be used within the MDX query window of SSMS to directly access...

17 min read

Getting Started with the SSAS Tabular Model

SSAS Tabular models are in-memory databases that model data with relational constructs such as tables and relationships, in order to provide a rapid and powerful...

16 min read

Developing a Report Definition Customization Extension for Multi-Language Reports

When you need to present the same SQL Server Reporting Services (SSRS) report in eight or more different languages, or in different formats for different...

31 min read

Bill Baker: Geek of the Week

Bill Baker had a considerable influence on the way that SQL Server evolved to deliver reporting services and business intelligence. Until 2008, Bill Baker headed...

8 min read

Report Builder 3.0: Adding Matrices to Your Reports

It is easy to create a basic matrix in Report Builder. However, it takes some practice in order to format and display the matrix exactly...

18 min read

Report Building 3.0: Adding Maps to Your Reports

With Report Builder and SSMS, there isn't much you can't do in the way of the common reports and visualisations. One of the more interesting...

17 min read