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
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers