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
PowerPivot/PowerView/PowerQuery/PowerBI
Power BI: Build a custom KPI scorecard
Patrick walks you through how you can use Power BI to build a custom KPI scorecard. The key is the UNICHAR DAX function. Demo files: https://guyinacu.be/demofiles
The post Power BI:...
2019-05-08
Extracting All The M Code From A Power BI Dataset Using The DISCOVER_M_EXPRESSIONS DMV
DMVs (Dynamic Management Views) are, as the Analysis Services documentation states, “queries that return information about model objects, server operations, and server health”. They’re also available in Azure Analysis...
2019-05-08
Multi-select Dynamic Titles in Power BI Desktop
After the dynamic titles in Power BI Desktop video, we had questions about how to do multi-select values. Patrick shows you how to do it! Demo files: https://guyinacu.be/demofiles
The post...
2019-05-07
Basics of Modeling in Power BI: What is a Dimension Table and Why Say No to a Single Big Table
I have previously written about relationships and the cardinality of the relationship. Now is a good time to explain the two types of tables we deal with every day...
2019-05-06
Cross-report Drillthrough in Power BI
Patrick leBlanc shows the magic of getting cross-report drillthrough working in Power BI.
2019-05-03
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
Blogs
What is a model database?
By gbargsley
Do you ever take a look at SSMS in the System Databases section? People...
Daily Coping 26 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Rowcount estimates when there are no Statistics
When you don't have statistics, what does SQL use to calculate the estimated number...
Forums
Issue in using Smartsheet CSharp SDK in SSIS Package
Hi, I am using Smartsheet CSharp SDK in SSIS Script Task. I added it...
converting smallint to int in ssis
Hi clever guys I have two tables named dbo.jade.store and dbo.stage.Store. The first...
Python Dictionary to DataFrame
Comments posted to this topic are about the item Python Dictionary to DataFrame
Ask SSC