Cross-report Drillthrough in Power BI
Patrick leBlanc shows the magic of getting cross-report drillthrough working in Power BI.
2019-05-03
PowerPivot/PowerView/PowerQuery/PowerBI
Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified
In this article, you will learn about one of the most important properties of a relationship called Cardinality.
2019-05-02
Taking Buttons in Power BI Desktop to the Next Level
Amanda Cofsky joins us to show how you can use buttons, in Power BI Desktop, to take your reports to the next level. Blank buttons can really make your...
2019-04-26
Using The “Skip Test Connection” Option For Power BI Data Sources To Avoid Scheduled Refresh Failures
One of the most popular blog posts I have written in recent years is this post on how the RelativePath and Query options for the Web.Contents() M function can...
2019-04-25
Improve Power BI Report performance by using the filter pane
If you are using slicers in your Power BI report, moving them off to the filter pane could improve performance. Patrick shows you what this could look like based...
2019-04-24
Power BI Streaming Datasets for More Than IoT
Power BI real-time streaming is the perfect solution for IoT. Whether processing data through Azure Stream Analytics, the PubNub data stream network, or a custom Internet of Things solution,...
2019-04-24
Power BI Paginated, DAX, Power Query and more… (April 22, 2019)
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup134 2 Minute Tuesday: https://guyinacu.be/databrickserror Patrick's tech video: https://guyinacu.be/modelview Adam's tech video: https://guyinacu.be/powerbigetdata Sources DAX 101: Summing...
2019-04-22
Export data from Power Query to Local Machine or SQL Server using R scripts
There is always a discussion on how to store back the data from Power BI to local computer or SQL Server Databases, in this short blog, I will show...
2019-04-22
Power Query Memory Usage, Dataflow Container Size And Refresh Performance
When Power BI dataflows were officially released a few weeks ago there was a new setting for Premium capacities mentioned briefly in the announcement blog post: Container Size. The...
2019-04-21
The new Power BI App Workspace experience
The new Power BI App Workspace experience GA'd in April of 2019. Adam takes you through what the new Power BI App Workspace is all about and what is...
2019-04-11
Blogs
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Start with the FabricTools PowerShell module
By Kamil
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...
Forums
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers