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
15,023 reads
Meagan Longoria
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
I’m Speaking at Virtual PASS Summit 2020
PASS Summit has gone virtual this year, but that isn’t keeping PASS from delivering a good lineup of speakers and activities. I’m excited to be presenting a pre-con and...
2020-08-06
23 reads
Refreshing a Power BI Dataset in Azure Data Factory
I recently needed to ensure that a Power BI imported dataset would be refreshed after populating data in my data mart. I was already using Azure Data Factory to...
2020-07-21 (first published: 2020-07-09)
413 reads
Data Visualization, Context, and Domain Expertise
I recently posted a graph to twitter and asked people to explain it. Let’s look at the graph. The graph is from Fitbit. It shows the number of steps...
2020-06-18 (first published: 2020-06-04)
412 reads
Power BI Data Viz Makeover: From Drab to Fab
On July 11 at 3pm MDT, Rob Farley and I will be hosting a webinar on report design in Power BI. We will take a report that does not...
2020-06-18
2 reads
An Updated Version of the Power BI Enterprise Deployment Whitepaper is Available
A new version of the Microsoft whitepaper “Planning a Power BI Enterprise Deployment” is now available. Once again, Melissa Coates (b|t) and Chris Webb (b|t) are the authors. I...
2020-06-16 (first published: 2020-05-28)
302 reads
Using Logic Apps in a Data Factory Execution Framework – Part 1
Data Factory allows parameterization in many parts of our solutions. We can parameterize things such as connection information in linked services as well as blob storage containers and files...
2020-05-22 (first published: 2020-05-07)
552 reads
Power Up: Exploring the Power BI Ecosystem, May 27-28
Next week I’m speaking at at the Dynamic Communities Power Up event titled “Exploring the Power BI Ecosystem“. It takes place on May 27 & 28, 2020. This exciting...
2020-05-21
19 reads
Check Out My MBAS Presentation on Power BI Report Accessibility
I had the privilege of working with Tessa Hurr (PM on the Power BI team) on a presentation for the 2020 Microsoft Business Applications Summit (MBAS) about five features...
2020-05-14
14 reads
Blogs
Making a PostgreSQL Backup in a Container
By Steve Jones
I needed to back up a PostgreSQL database as a part of the repro...
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
Forums
RLS Causing RBAR
Hi all, First I want to ask just a generic question. Does RLS in...
SQL2019 STANDARD max memory is 128Gb yet my Bufferpool exceeds this value
Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of...
Having issues installing SSIS extension for VS 2022 Community
I have installed the SSIS extension for VS 2022 community. When I go into...
Question of the Day
A Simple Choice
I have this data in a table?
CatIDCatName 3MonitorsWhat is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS cSee possible answers