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)
449 reads
Meagan Longoria
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)
179 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)
547 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)
378 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)
359 reads
Captioning Options for Your Online Conference
Many conferences have moved online this year due to the pandemic, and many attendees are expecting captions on videos (both live and recorded) to help them understand the content....
2020-12-08 (first published: 2020-11-24)
129 reads
DAX Logic and Blanks
A while back I was chatting with Shannon Lindsay on Twitter. She shares lots of useful Power BI tips there. She shared her syntax tip of the & operator...
2020-11-03 (first published: 2020-10-29)
280 reads
Stop Letting Accessibility Be Optional In Your Power BI Reports
We don’t talk about inclusive design nearly enough in the Power BI community. I was trying to recall the last time I saw a demo report (from Microsoft or...
2020-09-24 (first published: 2020-09-17)
291 reads
Downloading a CSV File from an API Using Azure Data Factory
In this article, learn how to use Azure Data Factory with a REST API to download files.
2020-09-07
14,861 reads
Fun with Power BI and Color Math
I recently published my color contrast report in the Power BI Data Stories Gallery. It allows you to enter two hex color values and then see the color contrast...
2020-09-01 (first published: 2020-08-20)
405 reads
Blogs
A New Word: Fardle-dun
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
FIRST_VALUE vs. Min: #SQLNewBlogger
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
Forums
Migrating from SSRS 2008 (SP Integrated) to 2022 (Native)
Has anyone done a migration from sharepoint integrated ssrs to native? I'm not finding...
NC index creation duration question
Hey All, My setup is as follows: Table with Clustered Index on ID col....
CPU Performance Advice in SQL Server 2005
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
Question of the Day
Subqueries II
What is wrong (if anything) with this code?
SELECT *
FROM Sales.SalesOrderHeader AS soh
WHERE customerid IN (SELECT soh.CustomerID
FROM Sales.Customer AS C
WHERE soh.CurrencyRateID = 1
ORDER BY c.ModifiedDate)
See possible answers