Power Query Performance And Expanding Columns
A critique of a first attempt to write an M query to convert a folder full of images to text that caused PowerQuery to perform multiple file reads
2019-05-31
PowerPivot/PowerView/PowerQuery/PowerBI
Introducing the Power BI Performance Analyzer
This article describes how to use and interpret the information provided by the Power BI Performance Analyzer, finding the bottlenecks in slow reports.
2019-05-31
R Script Visual in Power BI
Dave Mason takes us through his journey in learning how to visualize data with R, in Power BI desktop.
2019-05-31
2019-05-23
Power BI Basics of Modeling: Star Schema and How to Build it
Now that you know about the dimension and fact tab...
2019-05-22
2019-05-22
Storing Large Images In Power BI Datasets
Jason Thomas and Gerhard Brueckl have both blogged on the subject of storing images as text inside a Power BI dataset: http://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.html https://blog.gbrueckl.at/base64/ Since they wrote those posts, however,...
2019-05-20
Power Query Comes To Azure Data Factory With Wrangling Data Flows
One of the many big announcements at Build this week, and one that caused a lot of discussion on Twitter, was about Wrangling Data Flows in Azure Data Factory....
2019-05-10
Column Profiling in Power BI Desktop
Adam walks through column profiling within the Power BI Desktop. This includes the latest updates with the general availability (GA) within the April 2019 Power BI Desktop release. Demo...
2019-05-09
Move Your Shared Tables to Dataflow; Build a Consistent Table in Power BI
I have written previously about the use cases of Dataflow in Power BI, and one of them was using one Power Query table in multiple Power BI reports. However,...
2019-05-08
Blogs
Daily Coping 18 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
Daily Coping 17 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Number weeks from April to September for every year
I want to number weeks from April to September for every year, such that...
Index Fragmentation
I am looking into fragmentation in one of my databases and ran across these...
SSIS package with Multiple Streams
I have a package with has multiple streams and calls the same SP. Why...
Ask SSC