Calculating Age in Power BI
In week 26 of Workout Wednesday for Power BI, I asked people to calculate the age of Nobel laureates at the time they received the award. I provided some...
2021-07-21 (first published: 2021-07-09)
408 reads
Data Savvy
Altering a Computed Column in a Temporal Table in Azure SQL
System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data stored in the table at any point in time by storing an effective dated version...
2021-05-07 (first published: 2021-04-22)
207 reads
Control Flow Limitations in Data Factory
Control Flow activities in Data Factory involve orchestration of pipeline activities including chaining activities in a sequence, branching, defining parameters at the pipeline level, and passing arguments while invoking...
2021-04-06 (first published: 2021-03-25)
198 reads
Initial Thoughts on Dremio
I’ve been working on a project for the last few months with a client who has chosen to implement Dremio in Azure. Dremio is a data lake engine that...
2021-03-23 (first published: 2021-03-18)
106 reads
Azure Data Factory Activity Failures and Pipeline Outcomes
Question: When an activity in a Data Factory pipeline fails, does the entire pipeline fail?Answer: It depends In Azure Data Factory, a pipeline is a logical grouping of activities...
2021-02-25 (first published: 2021-02-18)
556 reads
Zooming In on a Power BI Report
Have you ever tried to use your browser to zoom in on a visual in a Power BI report? If you simply published your report and then zoomed in,...
2021-02-18 (first published: 2021-02-11)
457 reads
Granting ADLS Gen2 Access for Power BI Users via ACLs
It’s common that users only have access to certain folders in an Azure Data Lake Storage container. These permissions are provided not through Azure RBAC (role-based access control) roles...
2021-02-09 (first published: 2021-02-04)
184 reads
One Chart at A Time Video Series
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at a Time Video Series. It’s an effort to expand readers’ graphic literacy through short videos...
2021-02-03 (first published: 2021-01-27)
552 reads
Retrieving Log Analytics Data with Data Factory
I’ve been working on a project where I use Azure Data Factory to retrieve data from the Azure Log Analytics API. The query language used by Log Analytics is...
2021-01-05 (first published: 2020-12-24)
396 reads
Workout Wednesdays for Power BI in 2021
I’m excited to announce that something new is coming to the Power BI community in 2021: Workout Wednesday! Workout Wednesday started in the Tableau community and is expanding to...
2020-12-30 (first published: 2020-12-18)
368 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers