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
Now that you know about the dimension and fact tab...
2019-05-22
2019-05-22
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
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
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
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
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
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
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
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
By Steve Jones
A recent change made to Redgate Monitor to add a new alert for VLF...
In this post, the fifth in our series, I want to illustrate an example...
By Steve Jones
tangency– n. a fleeting glimpse of what might have been. I tend to live...
While I know that it will speed my learning to type queries as I...
I struggled with remembering the conventions I'd chosen when creating column names and data...
How do you configure the cluster resources to be able to use Distributed Transactions...
What is a partial backup for a read-only database?
See possible answers