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.

2018-06-12

2,710 reads

Power BI – Part 1: Introduction

  • Article

Power BI has been available for a number of years, but new functionality is added regularly. In this new series from Robert Sheldon, you will learn about the latest developments or get started with Power BI if you are new to it. Robert provides an overview of Power BI, the services and tools available in this article.

2018-06-06

4,118 reads

More Power BI to your Elbow

  • Article

Power BI Desktop continues to evolve. There have been many improvements to the reporting side that together make it easier to get from the data to the visualisation as quickly as possible. You can now create line charts that let users drill down into hierarchical data. There are now ways of adding dynamic reference lines to a visualization that provide users with relevant reference points. Robert Sheldon demonstrates how to combine these features to great effect.

2016-11-16

3,166 reads

Blogs

Error: 8623 - The query processor ran out of internal resources and could not produce a query plan

By

 Unfortunately a common error in many of our client environments is this: -- Error: 8623, Severity:...

Goal Progress– October 2020

By

This is my report, which continues on from the Aug report. After that report,...

Daily Coping 30 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

sys.dm_db_index_physical_stats returning wrong object_ID in MSDB database

By jackaroe

I'm running an index maintenance script on the MSDB database that loops through a...

Do I need a trigger?

By CanuckBuck

I want to test a condition during an insert or an update and only...

SQLServer Always-On and Bitlocker

By Lioh

Hi all, we have installed MSSQL 2017 with HA and Always on AGs on...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Best Query

See possible answers